| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of time
Hi
I need to calculate the difference of time between to dates. Here is my requirement Column M2: 4/10/2009 12:45:00 PM Column N2: 4/14/2009 8:11:00 AM I would like to display the difference of this 2 columns in hh:mm format. One important thing to note is we should not calculate weekends(Saturday and Sunday) And the business hours are from 9 AM to 6.30PM. So we have consider while calculating the difference. Can anyone please help me to resolve this. Thanks in Advance Raj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between times. Start time: 11:30PM End time: 5 AM | Excel Worksheet Functions | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Threaded Mode
