Hello everyone. I'm having a bit of trouble using the custom format function in Excel 2016. In a nutshell what I want is to be able to enter a time in the format hh:mm:ss:000, and add to that another time in the same format, and get the result. For example, I would like Excel to perform the following calculation:
12:34:56.789 + 1.234 = 12:34:58.023
I created a spreadsheet (attached) in an attempt to accomplish this but have thus far failed miserbaly. I have searched for "custom formatting time" but haven't been able to find the solution.
In my spreadsheet, I'd like to take the time entered into cell B6, add to it the seconds displayed in cells C10, C11, C12..., and display the results in D10, D11, D12...
So in my attached spreadsheet the result displayed in cell D10 should be, 00:10:59.457, but as you can see it is not.
I hope that's enough information. Thanks in advance for any help you can provide.
Bookmarks