| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compute time differences
GARYWC wrote:
What formula will compute the number of hours and minutes between the Start Time and the End time in each row? (Each cell is formatted as number, custom, type: h:mm AM/PM) Just "=B2-A2" and format the destination cells as time without AM/PM. -- Kneel! Bow! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
| compute date and time difference | Excel Worksheet Functions | |||
| Very long workbook computation time (F9 manual compute) | Excel Discussion (Misc queries) | |||
| what if problem to compute cost depending on time | Excel Discussion (Misc queries) | |||
| Macros to compute Sales figures Differences between Months | Excel Programming | |||
Threaded Mode
