Adding hours to get a decimal #

[alexhewett]

Im am trying to add hours together to get a decimal number. Ie: if I work 9:45 - 14:00 the answer should be 4.25 hrs. is there a way to get excel to do this.

 

[PaddyD]

multiply the result by 24

paddy

EDIT: on reflection, that was a bit terse! make sure you check out the help file for How Excel stores dates & times. see also:

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

and

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

for loads of info on date / time calculations
This message was edited by PaddyD on 2002-11-11 19:03

 

[Gemini]

Hi alexhewett


I have a formula that i'm working right now give about 5 mins and I'll put it up..testing it right now to see it works ok...

 

[Gemini]

Hi alexhewett

Start Finished total hrs work
9:45 14:00 4:15


In excel I used the insert function and used ABS. In the rows of the work sheet I formated the cells with format cell then used custom it was h:mm..I was off by 0:10
...Hope this helps you figure it out....I was close but I think that only counts in horse shoes...hhahaha..
This message was edited by Gemini on 2002-11-11 19:30

 

[maxflia10]

Another approach

=CEILING(((B1-A1+(B1 < A1))*24),0.01)

This formula takes into account 10:00pm to 1:00am also.

 

[Yogi Anand]

Hi alexhewett:

Welcome to the Board!
If the hours are within a 24 hour range, you can use ...
'=(B1-A1+(A1>B1)+0)*24
and format the result as Number with 2 decimal places