Can Time be converted to use in a calculation?

[Shadrack]

I have a field formatted to "Short Time" value. I get the display I want.
Example: 3:25 meaning 3 hours and 25 minutes.

I would like to figure a wage using the time and multiply it by a currency
value. Example: 3:25 (time worked) * $22.34 (hourly rate) = $(amount owed).

My question is how do I convert the time value so I can figure up the amount
owed?

 

[Allen Browne]

To get hours and fractions of an hour, use:
DateDiff("n", #0:00#, [time worked]) / 60

If you need to calculate the difference between Log On and Log Off times,
see:
http://allenbrowne.com/casu-13.html

 

[Joe Fallon]

Time worked is a very different thing from TIME.
I think of time worked as a Duration. I store it as a Double in terms of
Hours (or if rounding to the nearest tenth of an hour is allowed then to 1
decimal place.)

e.g.
3:30 (3 hours 30 minutes)
I would store as 3.5

Then it becomes simple to use the Hours Worked in your calculations.