Dates and times formulas

D

DB

I have a spreadsheet with a beginning date and time, in 2 columns. And in
another 2 columns, an ending date and time.

I would like to try to calculate the durations between the start date and
ending date. If possible I would also like to not count the weekends.

-Dan B.
 
M

Myrna Larson

Assuming the beginning date in A1, time in B1, ending date in C1, time in D1

=NETWORKDAYS(A1,C1)+(D1-B1)

assuming both dates are workdays. If the assumption isnt' correct, the formula
will be more complicated.
 
Top