hours worked

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I've set up a spreadsheet to track daily hours worked by
employees to then enter into Quickbooks.

The indvidual day formula works.

However, the total hours for the five days of the week
worked don't add up. It's as if the formula won't add the
individual cells from the forumula.

The formula I'm using to add the hours for the day is:
=sum(D5+D6+D7+D8+D9,"H:MM").

Can anyone help me?
 
Hello Barb

1. If you require a total in hours
a) =SUM(D5:D9) or
b) =D5+D6+D7+D8+D9

Use Custom Number Format [h]:mm

2. If your require a regular number (decimal number)

=SUM(D5:D9)*24 formatted general

N.B. Excel considers each hour 1/24 of a day.

With 8 hours per day the first 2 will show 40:00
and the last 40.
 
Back
Top