Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still have formula prob :o(
I still can't get it to work
I've got 12/12/2003 09:00 in once cell and 11/12/2003 09:00 in the other When I take the second away from the first I get 00:00:00 when it should tell me that 24 hrs has elapsed. :o( |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still have formula prob :o(
Libby,
What number format are you using in the result cell. It should be formatted as [hh]:mm:ss including the [] characters. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... I still can't get it to work I've got 12/12/2003 09:00 in once cell and 11/12/2003 09:00 in the other When I take the second away from the first I get 00:00:00 when it should tell me that 24 hrs has elapsed. :o( |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still have formula prob :o(
Yay thanks Chip!
I'd left out the [] How do they change the outcome though? Libby -----Original Message----- Libby, What number format are you using in the result cell. It should be formatted as [hh]:mm:ss including the [] characters. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... I still can't get it to work I've got 12/12/2003 09:00 in once cell and 11/12/2003 09:00 in the other When I take the second away from the first I get 00:00:00 when it should tell me that 24 hrs has elapsed. :o( . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still have formula prob :o(
Libby,
When Excel displays times, it displays them as "time-of-day" times, always between 00:00:00 and 23:59:59. The square brackets [] indicate to Excel not to "roll over" the time at 24:00:00, so a time of 36 hours, 30 minutes is displayed as 36:30 rather than 12:30. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... Yay thanks Chip! I'd left out the [] How do they change the outcome though? Libby -----Original Message----- Libby, What number format are you using in the result cell. It should be formatted as [hh]:mm:ss including the [] characters. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... I still can't get it to work I've got 12/12/2003 09:00 in once cell and 11/12/2003 09:00 in the other When I take the second away from the first I get 00:00:00 when it should tell me that 24 hrs has elapsed. :o( . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Still have formula prob :o(
FormatCellsCustom. In the Type box, enter something like [hh]:mm. The
square brackets tell Excel not to tip over at 24h -- Kind Regards, Niek Otten Microsoft MVP - Excel "Libby" wrote in message ... I still can't get it to work I've got 12/12/2003 09:00 in once cell and 11/12/2003 09:00 in the other When I take the second away from the first I get 00:00:00 when it should tell me that 24 hrs has elapsed. :o( |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks everyone
:o)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prob an easy one: How do i copy a formula EXACTLY as it is | Excel Worksheet Functions | |||
Formula prob - or is it validation? | New Users to Excel | |||
prob with dates in VBA | Excel Discussion (Misc queries) | |||
CSE Formula Prob | Excel Worksheet Functions | |||
A little help, prob simple to anyone else | New Users to Excel |