hours & minutes ADDITION IN EXCEL

[smasif]

i want hours & minutes in addition form in another two columns in exce
as formate given below :



A
HOURS MINUTES

1 20
1 00

B
TOTAL HR-MI
6000 45
6002 5
6003 5



Please reply on (e-mail address removed)

+-------------------------------------------------------------------
|Filename: hrmin.JPG
|Download: http://www.highdots.com/forums/attachment.php?attachmentid=330
+-------------------------------------------------------------------

 

[Peo Sjoblom]

Assume Hours start in A3, Minutes in B3, Total HR-Min for the hours in C2
and the total Minutes in D2, In C3 put

=IF(AND(A3="",B3=""),"",(A3+INT((D2+B3)/60))+C2)

in D3

=IF(AND(A3="",B3=""),"",MOD(D2+B3,60))

copy down

--
Regards,

Peo Sjoblom

(No private emails please)