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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.