| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time
How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes
Thanks Pete |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time
XL stores times as fractional days, so one way:
=TIME(12,35,0) - TIME(4, 0, 0) - TIME(0, 30, 0) another: A1: 04:00 am A2: 12:35 pm A3: =A2-A1-TIME(0,30,0) format A3 as a time, if necessary. If the times may span midnight, use =MOD(A2-A1-TIME(0,30,0),1) In article , Learning wrote: How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes Thanks Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Hybrid Mode
