Converting time to number, such as 02:45:00 to 2.75

[Norm Miller]

I would like to perform a calculation such as time multiplied by hours worked. Time is entered as 02:45:00 for 2 hours and 45 minutes. I want to multiply this by $30 an hour for 2.75 * $30. How can I convert time to a number so I can use it in such a calculation?

[Raybaudi]

Hi

simply divide by 3600 your time field.

So your calc will become:

timeField/3600*30

and the result: 82.5

[Norm Miller]

Thank you! I applied it to a summary field which didn't exactly work. So I applied it to a field in each record, and then summarized the result in a summary field, and it worked like a charm!