Need help calculating difference between dates

[STEMALO]

Hello,

I need to calculate the difference between a STOP and START and report the value in decimal format.

Here is what i am looking for.
START = 2011-07-11 11:46
STOP = 2011-07-13 10:40
STOP - START = 46:53:xx ( format used is : [h]:mm:ss

Now the tricky part (for me that is ) is that i need to convert the 53 minutes in decimal format. ie 53 divided by 60 which equals 0.88.
So the final result would be 46.88 hours.

Any help is greatly appreciated.

 

[GlennUK]

Simply multiply by 24, and have the cell format as decimal.

 

[STEMALO]

GleenUK you are brillant, i was looking at doing some LEFT and RIGHT with other formulas and never taught about simplicity...

Lesson learnt, all answers are simple, never complicate things more than they are.

Thanks again

 

[GlennUK]

That's great!