Excel Date and Time Calculation

May 11, 2009 at 09:52:59
Specs: Windows XP
I am trying to come up with a formula that will take 1/2/2009 6:30:00 PM (column C in Excel for Start Date & Time) and 1/3/2009 9:57:00 PM (column E in Excel for End Date and Time) and give me a total hours run (column F).

See More: Excel Date and Time Calculation

Report •


#1
May 11, 2009 at 10:00:39
Try E1-C1 with a Custom format of [h]:mm

Report •

#2
May 11, 2009 at 10:05:51
Thanks. Tried that. Only gives me 3 hours. Not 15 or so that I'm wanting. It would work if it was in the same date but crossing dates is messing me up.

Report •

#3
May 11, 2009 at 10:17:44
You may have seen DerbyDad03 reply, but you did read it:

The Custom Format must have the square brackets other wise you will not get the correct answer of:

27 hours 27 min.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 11, 2009 at 10:48:57
re: Not 15 or so that I'm wanting

I'm not sure how you can span more than a full day and only expect "15 or so" hours.

Everything I've read says the Earth day is getting longer, not shorter.


Report •

#5
May 11, 2009 at 11:17:16
Perhaps he means Uranus with a day of 17.9 earth hours
Or Saturn with a day of 10.2 earth hours.
I doubt it is Neptune’s as its days are longer than Uranus being 19.1 earth hours.

MIKE

http://www.skeptic.com/


Report •


Ask Question