May 29 2022 07:52 PM
I need a formula that will show a static date and time I start a project, and another formula for a different cell that will show the time I stop working on the project, and another formula to show the total time spent on the project for the day. I'm using Excel 365 on a Windows 10 computer 64 bit.
Thank you,
Colorado5280
May 29 2022 09:37 PM
SolutionUse keyboard shortcuts to enter the current date Ctrl ; (control plus semi-colon) and current time Ctrl Shift : (control plus shift plus colon). Do NOT use the NOW() function as it will continuously update itself.
To calculate duration, enter a formula like: =B1-A1, where B1 would contain the ending time and A1 the starting time.
Jun 04 2022 07:05 AM
Thank You!
May 29 2022 09:37 PM
SolutionUse keyboard shortcuts to enter the current date Ctrl ; (control plus semi-colon) and current time Ctrl Shift : (control plus shift plus colon). Do NOT use the NOW() function as it will continuously update itself.
To calculate duration, enter a formula like: =B1-A1, where B1 would contain the ending time and A1 the starting time.