Скачать или смотреть Make this Task Time Tracker in Google Sheets in 5 Minutes

Here's a simple time tracker you can create in Google Sheets in 5 minutes.

0:00 - Introduction: Tracking Task Times in Google Sheets
0:15 - Example Demo: Planning a Software Installation Project
1:26 - Changing Start Time or Duration (Auto-Recalculation)
2:05 - How to Set Up the Sheet: Custom Date/Time Formatting
2:47 - Formatting Start/End Times (Hide Repeating Date)
3:06 - Formatting Duration Column ([h]:mm for Cumulative Hours)
4:00 - Changing Date/Time & How It Updates Formulas
4:18 - The Formula Explained (Start Time + Duration)
4:49 - Works the Same in Microsoft Excel

It allows you to set a start date and time, and then calculates the start time of each subsequent step, if you have entered the step duration.

You can use this time tracker on tiny projects, especially ones where you want to know how long you've spent on each step.

#googlesheets #googlesheetstips