Tracking Time (Hours/Mins)

S

sdmccabe

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?
 
P

Peo Sjoblom

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
 
Top