How to I calculate the difference between 1AM and 3 AM? That's of course, 26 hours. I'd like the output to be in hours and minutes.
Thanks in advance.
How to I calculate the difference between 1AM and 3 AM? That's of course, 26 hours. I'd like the output to be in hours and minutes.
Thanks in advance.
Last edited by bodycode; 02-25-2013 at 11:16 AM.
I would suggest you put another column(s) of the dates of the time it was awaken and sleep.
You could try this...
Custom format cell A1 - m/d/yy h:mm
Custom format cell b1 - m/d/yy h:mm
Cell C1 formula would be "=B1-A1" Custom formatted to [h]:mm
Thank you very much. Messing with it for hours and hours, I finally did this. You are right. Problem solved.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks