Adding times together

  • Thread starter Thread starter Dave Elenor
  • Start date Start date
D

Dave Elenor

I need to add times together up to a 90 hrs

A1 14:30 Monday
A2 14:30 Tuesday
A3 14:30 Wednesday
A4 15:00 Thursday
A5 16:00 Friday
A6 12:30 Saturday

Over to 2 wks period, I havent to exceed over 90 hrs I have tried to
calculate the times but dont work
 
Try formatting the sum as [hh]:mm:ss

The []'s will keep the hours from rolling over into days.
 
I need to add times together up to a 90 hrs

A1 14:30 Monday
A2 14:30 Tuesday
A3 14:30 Wednesday
A4 15:00 Thursday
A5 16:00 Friday
A6 12:30 Saturday

Over to 2 wks period, I havent to exceed over 90 hrs I have tried to
calculate the times but dont work

What does "dont work" mean?

I add up those times and get 87 hours.

1. I entered the times in A1:A6 (I did not append the days of the week to the
time; rather I had the days of the week in column B).

2. In A8 I entered the formula =SUM(A1:A6).

3. I formatted the result as [h]:mm (Format/Cells/Number/Custom Type: [h]:mm)

The brackets [] around the 'h' cause it not to "roll-over" every 24
hours.


--ron
 

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

Back
Top