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
Bookmarks