| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtract date and time between columns
Hi,
How can I create a macro that would calculate the difference in date and time between 2 columns? I have column H and F with the cell format "yyyy-mm-dd h:mm:ss". I like to have column F subtract column H to get the date/time difference in the format "dd,h:mm:ss" and put the answer in column K the macro keep on doing that until it reaches a blank line.. Thanks very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract 12 hours from date/time | Excel Discussion (Misc queries) | |||
| how do I subtract time from a date to get an earlier date? | Excel Discussion (Misc queries) | |||
| How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| how can i subtract time from two different date? | Excel Worksheet Functions | |||
Threaded Mode
