| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula in excel to track times between two different dates ?
Hi!
If the difference is 24 hours or more, you'll have to include dates. Examples: A1 = 6:00 PM B1 = 11:00 AM (next day) Formula: format the cell as [h]:mm =B1-A1+(B1<A1) Returns 17:00 A1 = 2/20/2006 6:00 PM B1 = 2/21/2006 7:00 PM Returns 25:00 Biff "bmg" wrote in message ... i want to figure out the hours between two different times even if they go into the next day ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES | Excel Worksheet Functions | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Threaded Mode
