About Us

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins?	StargateFan	Excel Discussion (Misc queries)	8	January 7th 06 07:35 PM
Convert a number of minutes like 400 into hours and minutes	bloke	Excel Worksheet Functions	3	June 24th 05 05:00 PM
Adding hours and minutes..	Ron Rosenfeld	Excel Discussion (Misc queries)	2	June 11th 05 04:59 AM
comparing a value in a cell to see if it is higher than a number	PK	Excel Worksheet Functions	9	June 2nd 05 03:35 PM