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

--
Carl
-----------------------------------------------------------------------
CarlM's Profile: http://www.excelforum.com/member.php...fo&userid=3705
View this thread: http://www.excelforum.com/showthread.php?threadid=56779

Maybe a formula like

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

--
HTH

Bob Phillips

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

"CarlM" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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

--
Carl
-----------------------------------------------------------------------
CarlM's Profile: http://www.excelforum.com/member.php...fo&userid=3705
View this thread: http://www.excelforum.com/showthread.php?threadid=56779

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)

"CarlM" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Sorry its probably quite hard to interpret, but I dont want to have the
> dates at all, just the times, but it to be like this without the dates
> showing or me having to change them (I enter the date of the current
> day at the start of the log)
>
> 08/03/06 23:00
> 08/04/06 09:00
>
> Sorry if it was hard to interpret
>
> Carl
>
>
> --
> CarlM
> ------------------------------------------------------------------------
> CarlM's Profile:
http://www.excelforum.com/member.php...o&userid=37059
> View this thread: http://www.excelforum.com/showthread...hreadid=567790
>

try
=d15+1-c15

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"CarlM" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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

On Thu, 03 Aug 2006 13:17:55 +0100, Don Guillett
<(E-Mail Removed)> wrote:

> try
> =d15+1-c15
>