Let's say I want to use Excel to add an Activity Duration to a Start time to get the End Time. For example, add a Activity Duration of 40 minutes to a Start Time of 8:00 a.m. to get an End Time of 9:00 a.m. How do I do that in Excel?
Thanks!!!!!!!
-- Joe
2007-03-13 08:43:21 · 3 answers · asked by joegrant413 1 in Computers & Internet ➔ Software
Oops! The ending time should read "8:40 a.m.", not "9:00 a.m."
2007-03-13 08:50:32 · update #1
If you have the time entered in a cell like A1, then in B1, paste this
=TIME( HOUR( A1), MINUTE( A1) + 40, SECOND( A1))
Trust me, I am the VBAXLMan
2007-03-14 01:41:28 · answer #1 · answered by Anonymous · 0⤊ 0⤋
I used the above formula but substituted c1 for b1 so that I could have the adjusted time show in b1 and then carried the formula down. it's a neat thing :)
2014-09-05 08:53:52 · answer #2 · answered by Ravenfox1 1 · 0⤊ 0⤋
Type 0:40 exactly as in your example.
2007-03-13 16:11:40 · answer #3 · answered by unnga 6 · 0⤊ 1⤋