calculating time/dates differences

F

fvglassman

I'm looking for a formula that will allow me to calculate the difference
between the time and date of one day and the next. I also need to be able
subtract out the time between 17:00 ahd 08:30 as well as weekend days and
holidays. Example 6 June 16:51 to 7 June 9:51
 
B

Bob Phillips

Also, when you subtract dates/time, the answer is provided in DAYS. So if
you want the number of hours, you have to add /24 to the end of your
formula.
Click to expand...

I think you mean *24 Anne :)
 
Top