Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating time | Excel Discussion (Misc queries) | |||
Calculating Cells n% displayed in a cell? | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |