Calculation Question.

M

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.
 
M

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
 
Top