Hi,
I'm a beginner, so please be gentle.
I want to be able to calculate the difference in hours between two dates/times.
For example:
A1: 2011-12-12 12:00 B1: 2011-12-13 14:00
When I do a simple substraction in C1 (=B1-A1), it doesn't include the dates, so the result i 2 hours.
But I want it to be count both the 24 hours between the dates, and the hours: 26 hours.
I found a similar thread from 2008, where the code =INT(B1-A1)&TEXT(B1-A1,":hh:mm") were used.
But I didn't work for me.
So anyone who could help me with this?
Thanks in advance!
/Jon, Sweden
Bookmarks