Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula problem
Libby,
You can just subtract one datetime value from another. In the result cell, use a custom number format of [hh]:mm:ss . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... Hiya folks I had a spreadsheet with two columns. One column contained dates, the other contained times. I put the dates and times in one column, but if this can be done without doing that, then feel free to post that too :o) What I need to do is to take one date/time away from another to find out how many hours/mins/sec has elapsed between the two EG 12/Dec/2003 13:12 - 11/Dec/2003 09:50 Does anyone have any ideas? Thanking you Libby |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula problem
Hi Chip
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( -----Original Message----- Libby, You can just subtract one datetime value from another. In the result cell, use a custom number format of [hh]:mm:ss . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Libby" wrote in message ... Hiya folks I had a spreadsheet with two columns. One column contained dates, the other contained times. I put the dates and times in one column, but if this can be done without doing that, then feel free to post that too :o) What I need to do is to take one date/time away from another to find out how many hours/mins/sec has elapsed between the two EG 12/Dec/2003 13:12 - 11/Dec/2003 09:50 Does anyone have any ideas? Thanking you Libby . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem? | Excel Discussion (Misc queries) | |||
Formula problem | Excel Worksheet Functions | |||
Formula Problem | Excel Worksheet Functions | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Programming |