try
=d15+1-c15

--
Don Guillett
SalesAid Software

"CarlM" wrote in
message ...

Hey

So Im making a log to keep track of things, and I want to calculate my
sleep, but I don't want to have to write the date each time,

Went to Sleep: 23:00
Woke Up: , 09:00

So I just want to go down and write the times but if I do that the date
for the second time is assumed as the same day not the next day. Then
when I go to calculate my total with a simple =D15-C15 it calculates

08/03/06 23:00
08/03/06 09:00

NOT

08/03/06 23:00
08/04/06 09:00

any help would be apprieciated.

Carl


--
CarlM
------------------------------------------------------------------------
CarlM's Profile:
http://www.excelforum.com/member.php...o&userid=37059
View this thread: http://www.excelforum.com/showthread...hreadid=567790