Hello
I hope somebody can help me with the following:
Has anybody ever tried to recalculate numbers to times?
Let me be more specific: if I have 2 times, let's say 37:28 seconds and
36:94 seconds, how can I re-calculated this to 1:14:22?
Adding the 28 and 94 gives me 1 sec 22: for the seconds:
(int(122/100)=1, the rest = 122 -/- (int(122/100)*100)
=22
37 and 36 = 73 which equals 1 min 13 secs
(similar: mins = int(73/60), secs = 73 -/-
(int(73/60)*60) = 13
Together: 1 min, 13 + 1 = 14 seconds and 22
My problem is that I don't know how to translate this into a formula,
or better VBA?
I think that if I want to capture this only in formulas I may need a
lot of columns for 1 calculation, so if it is possible in VBA this has
my preference!
Who can help me?
Thanks for your help
Hein
--
Hein
------------------------------------------------------------------------
Hein's Profile:
http://www.excelforum.com/member.php...o&userid=24744
View this thread:
http://www.excelforum.com/showthread...hreadid=472455