Creating a Real Time Elapsed Time Counter for an excel spreadsheet. Showing total elapsed time wedged in between Time In & TIme Out.
Need to do two things in excel.
Is this possible to do. ..?
Column A Column B Column C Column D
Date Start TIME IN ELAPSED TIME TIME OUT
12/27//2018 12:54:28 Displays counter in real time. 12:56:58
Hrs:Min:Sec 00: 02: 28..,29..,30
- When I move to a cell the "TIME IN" cell automatically picks up the time stamp for the current date and time. Colum A & B
- Once that cell (Column B) is filled with a time stamp another cell in a corresponding row/column starts an elapsed time clock that starts counting up.
- Then when I move to the "TIME OUT" cell the elapsed time stops leaving the total elapsed time in the
Is this possible to do. ..?
Column A Column B Column C Column D
Date Start TIME IN ELAPSED TIME TIME OUT
12/27//2018 12:54:28 Displays counter in real time. 12:56:58
Hrs:Min:Sec 00: 02: 28..,29..,30
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER