Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Network days rounding off hours
I use Networkdays formula to calculate difference bwtween 2 dates,if the end
date is beyond 12 hours the formula returns 1, so my calculation of SLA is going vague. Is there any formula that we can use which will exclude weekdays and will report in hours. Or is it possible in vba to do this cutom requirement |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |