I assume you mean 37 and 28/100 seconds, and 36 and 94/100 seconds? If so you
can enter these times in a worksheet cell using this data entry format:
00:00:37.28 and 00:00:36.94. Set the format of the cells to hh:mm:ss.00 Then
simply add the cells (e.g. =A1+B1). YOu may have to set the format of the
result cell, too.
You can also enter the numbers as 37.28 and 36.94. Then to add them, use the
formula
=(A1+B1)/86400
and format as above. Excel stores a time as a fraction of a day. The division
by 86400 converts seconds to days.
On Sun, 2 Oct 2005 14:49:22 -0500, Hein
wrote:
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
|