Can Time be converted to use in a calculation?

  • Thread starter Thread starter Shadrack
  • Start date Start date
S

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?
 
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.
 
Back
Top