| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Subtracting Cells formatted with Date AND Time to get hours?
Thanks in advance for the help. Is it possible to subtract 2 cells
that are both formatted as mm/dd/yyyy h:mm to just have it subtract the times to get a total # of hours between the 2. For example, A1 is 1/1/05 13:00 and B1 is 1/2/05 14:30. I'd like C1 to give me the total of 25:30. This forum is always a great place for help. Thanks again in advance for your help. mcr1 |
|
#2
|
|||
|
|||
|
=B1-A1 and format as [hh]:mm
-- HTH Bob Phillips "mcr1 - ExcelForums.com" wrote in message ... Thanks in advance for the help. Is it possible to subtract 2 cells that are both formatted as mm/dd/yyyy h:mm to just have it subtract the times to get a total # of hours between the 2. For example, A1 is 1/1/05 13:00 and B1 is 1/2/05 14:30. I'd like C1 to give me the total of 25:30. This forum is always a great place for help. Thanks again in advance for your help. mcr1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Linear Mode
