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