Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |