scheins Wrote:
This is my set up
col a col b col c col d
Date Start End Total Hours
8-Sep 8:45 AM 12:30:00 3:50


i tried to rework your formula to what i have but it did not work


Your cells for "Start" and "End" must be time formatted for the formula
to work.

BTW, how can (12:30 - 8:45) be equal to 3:50? Shouldn't this be 3:45?


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=475077