Home |
Search |
Today's Posts |
#1
|
|||
|
|||
re calculating numbers to times
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
NEED HELP - Calculating dates and times | Excel Discussion (Misc queries) | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |