Converting time 7:45 as 7.75 in number
421951May 24 2004 — edited May 24 2004I am storing time as 7:45 (7 hours and 45 minutes)
Has anyone written any function to convert this time 7:45 to 7.75 in number.
0.15 - > .25
0.30 - > .50
0.75 - > .75
1.00 - > 1.00
Time is stored right now as a character field. Now need to convert this into number for reporting purposes.