| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time conversion
converting hrs. and mins. to mins. then subtracting a given amount of mins.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time conversion
Hi
Without converting to minutes first, with time in A1 in the form 10:45 =A1-Time(0,5,0) will deduct 5 minutes and give a result of 10:40 -- Regards Roger Govier "thisguy" wrote in message ... converting hrs. and mins. to mins. then subtracting a given amount of mins. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time conversion
To convert a time (hh:mm:ss) to minutes, multiply by 1440 (the number of minutes
in a day). Format as a number. Then subtract your minutes. -- Regards, Fred "thisguy" wrote in message ... converting hrs. and mins. to mins. then subtracting a given amount of mins. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic time conversion in the SAME cell | Excel Discussion (Misc queries) | |||
| Time conversion in Excel | Excel Worksheet Functions | |||
| time conversion GMT to Pacific | Excel Discussion (Misc queries) | |||
| Time conversion | Excel Worksheet Functions | |||
| Excel Time Conversion | Excel Discussion (Misc queries) | |||
Linear Mode
