View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22)

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)



In article ,
Abrahams wrote:

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