| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate working hours from a start and finish time over several
I am trying to calculate the working time in the format [hh]:mm for assigned
tasks so that i will be able to log the rate at which different tasks can be completed and help schedlue for the future. I was planning to use a macro to copy and paste the value from a cell containing the value =NOW() to create the start and end time. which is easy enough. my problem lies with getting the number of worked hours based on working pattern of 9-5 monday to friday out of the start and finish time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate working hours from a start and finish time over several
Hi Jive,
Please specify what does "working pattern of 9-5 monday to friday" mean! Regards, Stefi €˛Jive€¯ ezt Ć*rta: I am trying to calculate the working time in the format [hh]:mm for assigned tasks so that i will be able to log the rate at which different tasks can be completed and help schedlue for the future. I was planning to use a macro to copy and paste the value from a cell containing the value =NOW() to create the start and end time. which is easy enough. my problem lies with getting the number of worked hours based on working pattern of 9-5 monday to friday out of the start and finish time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting no of hours from start to finish | Excel Discussion (Misc queries) | |||
| Start & Finish Time | Excel Worksheet Functions | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| time addition to predict finish time | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Linear Mode
