add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22)

A

Abrahams

I need to add up numbers in a spreadsheet to show as hours and minutes (not
times). The purpose of this sheet is to add up hours worked daily and then
add them up to show weekly.

Example Monday = 7.24 and Tuesday = 2.58 I want them to show as 10.22 worked
 
J

JE McGimpsey

It would be *much* easier if you just used XL times. For instance

A1: 7:24
A2: 2:58
A3: =SUM(A1:A2) ===> 10:22

when A3 is formatted with Format/Cells/Number/Custom "[h]:mm".

Otherwise you can use something like:

A3: =INT(A1) + INT(A2) + INT((MOD(A1,1)+MOD(A2,1))/0.6) +
MOD((MOD(A1,1)+MOD(A2,1)),0.6)
 
Top