|
Calculating Sleep
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 |
Calculating Sleep
Maybe a formula like
=IF(B2<B1,A1+1,A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "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 |
Calculating Sleep
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 |
Calculating Sleep
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" wrote in message ... 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 |
Calculating Sleep
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 wrote: try =d15+1-c15 |
| All times are GMT +1. The time now is 11:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com