1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula do Elapsed Time Addition

I'm trying to figure out an equation that will allow me to add a start time in one field(7:30 am in B1) to an elapsed time in another (8 hours in B2) to return an end time in 24 hour time in the third (15:30 in B3).

My goal is to create a calculator so that I can figure out different end times by changing the values in B1 & B2 while leaving the equation in B3 intact. Is there a way to that?

submitted by /u/Fickle-Aardvark6907
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#real-time data collaboration
#real-time collaboration
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#formula generator
#elapsed time
#addition
#start time
#end time
#calculator
#24 hour time
#equation
#B1
#B2
#B3
#time calculation
#input fields