Dates and times formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
Sumproduct with multiple date criteria 1
Formula for calculating time period between 2 dates 3
day of the week and date formula 2
Calculate times between dates and times in Excel 1
Formula help: Duration Without Weekend Days 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Conditional Formating based on start and end dates 1

Back
Top