Calculating total hours

[gary66]

If i have 4 workers who worked for 8:25, and multiply that, (ie, 4x8:25
I should get 33 hours they worked total.
But in Excel, I am getting 9:40.
What formula do I need to put in a cell to get 33 hours?

 

[JulieD]

Hi Gary

Excel doing this as 8:25 looks like 8:25am to it, if you just enter 8.25
instead of the 8:25 it will work. If that's not an option then use the
following formula
=A1*B1*24
where A1 contains 8:25
and B1 contains 4
and format the result as General (format / cells / numbers tab - general)

Cheers
JulieD

 

[Guest]

Try using the conversions on the chart linked below for your minutes...
home.comcast.net/~phrostyphish/time_conversion.xls

This is how I calculate time for my company. It's worked great for years
Hope this helps.