Thread: Calculate time (excluding weekend (48 hrs))
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AndyO_UK AndyO_UK is offline
external usenet poster
  
Posts: 15
Default Calculate time (excluding weekend (48 hrs))
Need help to calculate the total number of hours excluding the 48 hrs of a
weekend.

Currently my spreadsheet looks like this:

C3 (date/time) start
D3 (date/time) end
E3 number value total hours (=(D3-C3)*24)

Grateful for any help.
Reply With QuoteReply With Quote