Converting Time To a Number
I am building a time card and I would like to convert the total time worked is not working out so good for me. Here is what I have so far.
My calculation is:
Time End-Time Start - Lunch*60= Total time worked
All Fields are "Time" fields except for "Total Time Worked" I switched it back an fourth.
5:30pm -8:00am-:30 = 60300.00 (if Total time worked is a Number)
5:30pm -8:00am-:30 = 8:45:00 (if Total time worked is Time)
I would like it to read 8.75
What would be the best way to do this?