jumpergirl 0 #1 October 8, 2005 I have a question about a formula. I'm trying to add times, hh:mm:ss, but not AM or PM times. Freefall times. Can someone help me? I've been trying to find the right formula, but I just can't seem to get it. Thanks! Quote Share this post Link to post Share on other sites gemini 0 #2 October 8, 2005 Format the cell for 24hr time in HH:MM:SS format. Then just add the cells you need as you usually do. The formatting will handle the 60 min/60 sec issues you have. Blue skies, Jim Quote Share this post Link to post Share on other sites Gawain 0 #3 October 8, 2005 Select the cells/columns you want to format and pick "Custom" then "hh:mm:ss". The only caveat to this is that you will have to enter your times in that format (e.g. 00:01:10 for a minute, ten seconds of freefall). But, running a formula to add the times together is as easy as any other basic formula. Another option is to enter the times as numbers with decimals (e.g. 1:10 would be 1.17, or 1:15 would be 1.25 or 0:55 would be 0.917, etc.). Personally, I'd go with the first option.So I try and I scream and I beg and I sigh Just to prove I'm alive, and it's alright 'Cause tonight there's a way I'll make light of my treacherous life Make light! Quote Share this post Link to post Share on other sites jumpergirl 0 #4 October 8, 2005 Thanks, that's what Jim said as well. I was hoping to avoid that, being lazy ya know, but oh well. This will still work. Thanks guys. Quote Share this post Link to post Share on other sites Feeblemind 1 #5 October 8, 2005 Or you can try this: www.dropzone.com/files/ffcalc20.zip Fire Safety Tip: Don't fry bacon while naked Quote Share this post Link to post Share on other sites jumpergirl 0 #6 October 8, 2005 Great!! That's much better!! LOL Quote Share this post Link to post Share on other sites SuFantasma 0 #7 October 9, 2005 That's too much effort, just use the RANDOM number generator....Y yo, pa' vivir con miedo, prefiero morir sonriendo, con el recuerdo vivo". - Ruben Blades, "Adan Garcia" Quote Share this post Link to post Share on other sites Join the conversation You can post now and register later. If you have an account, sign in now to post with your account. Note: Your post will require moderator approval before it will be visible. Reply to this topic... × Pasted as rich text. Paste as plain text instead Only 75 emoji are allowed. × Your link has been automatically embedded. Display as a link instead × Your previous content has been restored. Clear editor × You cannot paste images directly. Upload or insert images from URL. Insert image from URL × Desktop Tablet Phone Submit Reply 0 Go To Topic Listing
gemini 0 #2 October 8, 2005 Format the cell for 24hr time in HH:MM:SS format. Then just add the cells you need as you usually do. The formatting will handle the 60 min/60 sec issues you have. Blue skies, Jim Quote Share this post Link to post Share on other sites
Gawain 0 #3 October 8, 2005 Select the cells/columns you want to format and pick "Custom" then "hh:mm:ss". The only caveat to this is that you will have to enter your times in that format (e.g. 00:01:10 for a minute, ten seconds of freefall). But, running a formula to add the times together is as easy as any other basic formula. Another option is to enter the times as numbers with decimals (e.g. 1:10 would be 1.17, or 1:15 would be 1.25 or 0:55 would be 0.917, etc.). Personally, I'd go with the first option.So I try and I scream and I beg and I sigh Just to prove I'm alive, and it's alright 'Cause tonight there's a way I'll make light of my treacherous life Make light! Quote Share this post Link to post Share on other sites
jumpergirl 0 #4 October 8, 2005 Thanks, that's what Jim said as well. I was hoping to avoid that, being lazy ya know, but oh well. This will still work. Thanks guys. Quote Share this post Link to post Share on other sites Feeblemind 1 #5 October 8, 2005 Or you can try this: www.dropzone.com/files/ffcalc20.zip Fire Safety Tip: Don't fry bacon while naked Quote Share this post Link to post Share on other sites jumpergirl 0 #6 October 8, 2005 Great!! That's much better!! LOL Quote Share this post Link to post Share on other sites SuFantasma 0 #7 October 9, 2005 That's too much effort, just use the RANDOM number generator....Y yo, pa' vivir con miedo, prefiero morir sonriendo, con el recuerdo vivo". - Ruben Blades, "Adan Garcia" Quote Share this post Link to post Share on other sites Join the conversation You can post now and register later. If you have an account, sign in now to post with your account. Note: Your post will require moderator approval before it will be visible. Reply to this topic... × Pasted as rich text. Paste as plain text instead Only 75 emoji are allowed. × Your link has been automatically embedded. Display as a link instead × Your previous content has been restored. Clear editor × You cannot paste images directly. Upload or insert images from URL. Insert image from URL × Desktop Tablet Phone Submit Reply 0 Go To Topic Listing
Feeblemind 1 #5 October 8, 2005 Or you can try this: www.dropzone.com/files/ffcalc20.zip Fire Safety Tip: Don't fry bacon while naked Quote Share this post Link to post Share on other sites
jumpergirl 0 #6 October 8, 2005 Great!! That's much better!! LOL Quote Share this post Link to post Share on other sites SuFantasma 0 #7 October 9, 2005 That's too much effort, just use the RANDOM number generator....Y yo, pa' vivir con miedo, prefiero morir sonriendo, con el recuerdo vivo". - Ruben Blades, "Adan Garcia" Quote Share this post Link to post Share on other sites Join the conversation You can post now and register later. If you have an account, sign in now to post with your account. Note: Your post will require moderator approval before it will be visible. Reply to this topic... × Pasted as rich text. Paste as plain text instead Only 75 emoji are allowed. × Your link has been automatically embedded. Display as a link instead × Your previous content has been restored. Clear editor × You cannot paste images directly. Upload or insert images from URL. Insert image from URL × Desktop Tablet Phone Submit Reply 0
SuFantasma 0 #7 October 9, 2005 That's too much effort, just use the RANDOM number generator....Y yo, pa' vivir con miedo, prefiero morir sonriendo, con el recuerdo vivo". - Ruben Blades, "Adan Garcia" Quote Share this post Link to post Share on other sites