4 Replies Latest reply on Feb 25, 2013 5:20 AM by CraigFiore

    Converting Time To a Number

    CraigFiore

      Title

      Converting Time To a Number

      Post

           Hello,

           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.

           Craig