networkdays
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.
|