Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
Hoping someone can help me - I've got access to the "networkdays" function, but am trying to calculate the number of hours elapsed, where working day is from 08:00 to 18:00 and start time is cell J2 (1/10/2004 2:25:00) , end date and time is cell AJ3 (04/10/2004 17:02:00). Should return something like 12:37. However, it doesn't seem to like the date/time format in the same cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NETWORKDAYS | New Users to Excel | |||
UUsing the NetworkDays Function with IF Statements | Excel Worksheet Functions | |||
networkdays or dias.lab | Links and Linking in Excel | |||
Networkdays shows as #NAME even though I have the toolpack instal. | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |