Calculation Question.

[MS User]

Hi all. I have two columns as follows:

Time In: (format is Date/Time)
Time Out: (format is Date/Time)

I have a third column that I simply want to have a calculated total of:
Time Out - Time In

And display as a number value.

When I do so with this example:

Col1 Col2
10:30 AM - 3:45 PM

I get: 0.22 as a result.

Can anyone help (I've tried On Line Help), but just can't figure it out.

Thanks

ps: If I'm in the wrong NG, please let me know.

 

[Gord Dibben]

Time out - Time in = 0.22

Multiply the 0.22 by 24 to get 5.25 hours

The 0.22 is a fractional part of a day.

A day is 1...........8 hours would be .333

For more on Dates and Arithmetic with dates and times see Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#AddingDates


Gord Dibben MS Excel MVP

 

[MS User]

DOH. I formatted the cells as Custom (h:mm) and now all works as I wanted.

Sorry for the post, I should have checked the Custom settings first.

Cheers