Tracking Time (Hours/Mins)
 

I would appreciate a suggested formula for tracking time, actually duration,
subtracting the time in one posted column from another. The elapsed time
will be within a twenty four hour period, so the date/time format need not
include one day to another, if that matters. The result will be used to
produce a dollar amount, so the unit result should probably be minutes, as
opposed to a decimal €“ right? Is this possible?

If the rate is for hours use

=(End-Start)*24*payrate

if it is pay per minute

=(End-Start)*1440*payrate

format as curremyc, number or general or else you'll get the amount in time
format which can look funny

Regards,

Peo Sjoblom



"sdmccabe" wrote:

I would appreciate a suggested formula for tracking time, actually duration,
subtracting the time in one posted column from another. The elapsed time
will be within a twenty four hour period, so the date/time format need not
include one day to another, if that matters. The result will be used to
produce a dollar amount, so the unit result should probably be minutes, as
opposed to a decimal €“ right? Is this possible?