| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and time difference
Hi,
I am looking for a formula that works out the time difference, in days, hours and minutes between 2 cells (each cell containting this info: ddmmyyyy hhmmss). This has to take into account the working hours being 8 - 6 and must not include weekends. Any ideas gratefully accepted. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time difference
Hi
Have a look at this page from Chip's site: http://www.cpearson.com/excel/DateTimeWS.htm#WorkHours Hope this helps. Andy. "Danieljesse" wrote in message ... Hi, I am looking for a formula that works out the time difference, in days, hours and minutes between 2 cells (each cell containting this info: ddmmyyyy hhmmss). This has to take into account the working hours being 8 - 6 and must not include weekends. Any ideas gratefully accepted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Difference of date & time in minutes | Excel Worksheet Functions | |||
Hybrid Mode
