Hi I would like to have a macro compare to columns's time and display the difference in (h:m:s).
Example in the sheet attached
Hi I would like to have a macro compare to columns's time and display the difference in (h:m:s).
Example in the sheet attached
Last edited by jfish; 04-14-2019 at 10:23 AM. Reason: solved
This can be done more easily with a formula:
=DATEVALUE(LEFT(B2,10))+TIMEVALUE(MID(B2,12,12))-DATEVALUE(LEFT(A2,10))-TIMEVALUE(MID(A2,12,12))
Use custom format
[h]:mm:ss
Implemented in attached.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks