Calculating Sleep

[CarlM]

Hey

So Im making a log to keep track of things, and I want to calculate m
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 dat
for the second time is assumed as the same day not the next day. The
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.

Car

 

[Bob Phillips]

Maybe a formula like

=IF(B2<B1,A1+1,A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[CarlM]

Sorry its probably quite hard to interpret, but I dont want to have th
dates at all, just the times, but it to be like this without the date
showing or me having to change them (I enter the date of the curren
day at the start of the log)

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

Sorry if it was hard to interpret

Car

 

[Bob Phillips]

Now you have completely lost me.

What will you enter, and what do you want to see?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Don Guillett]

try
=d15+1-c15

 

[SteveW]

or even
=if(D15<C15,D15+1-C15,D15-C15)

just in case you have a nap during the day
(or like me work nights)

Steve