AnsweredAssumed Answered

Converting Time To a Number

Question asked by CraigFiore on Feb 23, 2013
Latest reply on Feb 25, 2013 by CraigFiore


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?

     Thank you.