ExcelBanter - hours & minutes ADDITION IN EXCEL

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)

"smasif" wrote in message
...

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

A
HOURS MINUTES

1 20
1 00

B
TOTAL HR-MIN
6000 45
6002 5
6003 5

Please reply on

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

--
smasif
------------------------------------------------------------------------
smasif's Profile: http://www.highdots.com/forums/m1588
View this thread: http://www.highdots.com/forums/t3155391