Working with Time durations

[SJACKSON1234]

Hi,

I'm trying to work with time durations in excel, Currently I have the cells fomatted to the custom [hh]:mm:ss and in general everything works okay - the issue being that when i try formula to convert from hours into working days I encounter issues where the hours exceed 24.

eg.

I have input '180:00:00' into the cell which displays fine, however in the formula bar Excel shows '07/01/1900 12:00:00' which make it impossible to use the cell in a formula when say multiplying by a cost. Multiplying the '180:00:00' cell by $50 gives $375.

Essentially I'm asking if it is possible to work in hour durations with excel formulas where the hours are greater than 24

Thanks in advance

 

[stumac]

excel stores dates as numbers starting at 0 = 00/01/1900,1 = 01/01/1900

Your calculation is multiplying days x the hourly rate - if you multiply by 24 you should get correct result.