| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Difference in time
What do I have to do to find out how many hours and minutes between the 2
following date/times 25 Feb 2006 0908 AM 27 Feb 2006 0200 PM I have tried some formatting but never got the right answer Thanks in advance PCOR |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Difference in time
You don't say what formtting you have tried but assuming that the date &
time is in the same cell, I got 52:52 by formatting the subtraction cell as [h]:mm -- HTH Sandy with @tiscali.co.uk "pcor" wrote in message ... What do I have to do to find out how many hours and minutes between the 2 following date/times 25 Feb 2006 0908 AM 27 Feb 2006 0200 PM I have tried some formatting but never got the right answer Thanks in advance PCOR |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Difference in time
Check Chip Pearson's site
http://www.cpearson.com/excel/datetime.htm#WorkHours "pcor" wrote: What do I have to do to find out how many hours and minutes between the 2 following date/times 25 Feb 2006 0908 AM 27 Feb 2006 0200 PM I have tried some formatting but never got the right answer Thanks in advance PCOR |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Difference in time
Thanks again..I did finally get it going
"Sandy Mann" wrote: You don't say what formtting you have tried but assuming that the date & time is in the same cell, I got 52:52 by formatting the subtraction cell as [h]:mm -- HTH Sandy with @tiscali.co.uk "pcor" wrote in message ... What do I have to do to find out how many hours and minutes between the 2 following date/times 25 Feb 2006 0908 AM 27 Feb 2006 0200 PM I have tried some formatting but never got the right answer Thanks in advance PCOR |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Difference in time
Thanks
"Duke Carey" wrote: Check Chip Pearson's site http://www.cpearson.com/excel/datetime.htm#WorkHours "pcor" wrote: What do I have to do to find out how many hours and minutes between the 2 following date/times 25 Feb 2006 0908 AM 27 Feb 2006 0200 PM I have tried some formatting but never got the right answer Thanks in advance PCOR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
| How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
| Time Difference | Excel Worksheet Functions | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Linear Mode
