| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate dates and times, w/answer of days & hours
How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell. For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and number of hours in this length of time? What is the total hours in this length of time? I did look for the DateIf funtion in my Excel 2003 version, I did not locate it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| find days and hours between 2 sets of dates and times | Excel Discussion (Misc queries) | |||
| How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
| How to calculate days:Hours:Minutes: | Excel Worksheet Functions | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Threaded Mode
