Excel 2007 : Adding hours and minutes each day and by job code

[tinnie]

I am using excel to upload to payroll. I need excel to add the minutes put in as 8.0 + 3.30 + 3.30, = 15 instead of 14:60. How can I populate the hours/minutes and what function do I use to sum or sumproduct?

thanks in advance

[tigeravatar]

tinnie,

Welcome to the forum!
Try DollarDE formula:
=DOLLARDE(8+3.3+3.3,60)/1440

And format cell as Time

[Richard Buttrey]

Hi,

To sum and convert the entries, assuming they're in A1:A3 use the array formula (entered with Ctrl-Shift-Enter)
=SUM(INT(A1:A10))+SUM(A1:A10-INT(A1:A10))/0.6

change the A1:A10 range as necessary

There's probably a more elegant way but one way to sum the hours for a particular job, assuming the job numbers are in B1:B10 and the job number you're looking to sum is in C1

=INT(SUMPRODUCT((A1:A10)*(B1:B10=C1)))+(SUMPRODUCT((A1:A10)*(B1:B10=C1))-INT(SUMPRODUCT((A1:A10)*(B1:B10="A"))))/0.6