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