software

i want hours amp; minutes in addition form in another two columns in excel
as formate given below :
A
HOURSMINUTES

120
1 00

B
TOTAL HR-MIN
6000 45
6002 5
6003 5
Please reply on -------------------------------------------------------------------
|Filename: hrmin.JPG |
|Download: www.highdots.com/forums/attachment.php?attachmentid=330|
-------------------------------------------------------------------

--
smasif
------------------------------------------------------------------------
smasif's Profile: www.highdots.com/forums/m1588
View this thread: www.highdots.com/forums/t3155391Assume 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=quot;quot;,B3=quot;quot;),quot;quot;,(A3 INT((D2 B3)/60)) C2)

in D3

=IF(AND(A3=quot;quot;,B3=quot;quot;),quot;quot;,MOD(D2 B3,60))

copy down

--
Regards,

Peo Sjoblom

(No private emails please)quot;smasifquot; gt; wrote in message
...
gt;
gt; i want hours amp; minutes in addition form in another two columns in excel
gt; as formate given below :
gt;
gt;
gt;
gt; A
gt; HOURS MINUTES
gt;
gt; 1 20
gt; 1 00
gt;
gt; B
gt; TOTAL HR-MIN
gt; 6000 45
gt; 6002 5
gt; 6003 5
gt;
gt;
gt;
gt; Please reply on
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: hrmin.JPG |
gt; |Download: www.highdots.com/forums/attachment.php?attachmentid=330|
gt; -------------------------------------------------------------------
gt;
gt; --
gt; smasif
gt; ------------------------------------------------------------------------
gt; smasif's Profile: www.highdots.com/forums/m1588
gt; View this thread: www.highdots.com/forums/t3155391
gt;