Excel: counting times and dates during non-traditional hours

D

Deuces

We have to work 12 nontraditional hours per month at my job. These are hours after 6 and any hours on the weekend. I am trying to make a spreadsheet that keeps up with people's hours and gives the running month total.

So if I put that I came in at 10 AM in one weekday cell and that I left at 8 PM in the other cell for that weekday, and I put in that I worked 9-6 in the two cells for a Saturday, I would want it to say 10 hours in the total.

How would I go about doing that?
 

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

Calculate Total Hours when Overlapping Occurs 0
Formula for calculating target hours against actual hours 12
calculating times 1
overtime during weekdays and weekend ( more specified) 2
End Date/Time adding business hours 1
Calculate end date and time 1
Excel Facetime Measurement 1
Subtracting Dates to Find the Difference in Hours 6

Top