PDA

View Full Version : Simple one - one cell - another cell, both datetime cells



Salient
09-06-2012, 04:55 PM
What's actually being returned when you subtract one datetime cell from another - Hours?????

mancubus
09-07-2012, 12:17 AM
08.18.2012 19:00
08.10.2012 12:00
.......8.291666667

days.

integer part represents day difference and decimal part hour difference. (7 hours = 0.291666667 days, 1 day / 24 hour * 7 hour)


http://www.cpearson.com/excel/datearith.htm