Time tracking can be a hassle, but not with Excel! Learn how to convert date and time into minutes and calculate time differences with ease. This tutorial shows how to use the ROUND function and a simple multiplication and division approach to make your time calculations a breeze.
MY FAVOURITE TOOLS & GEAR👍:
🚀 Tubebudy - Create and Grow KZread Channel: bit.ly/3zPDOTX
🎥 Camtasia - Seamless Screen and Audio Recording: bit.ly/3W8Nq3H
🎵 EpidemicSound - Music for every type of content: bit.ly/3ycY1Cw
#ExcelTips #TimeManagement #ExcelTutorial #TimeConversion #ProductivityHacks
----
Converting date and time into minutes…
Steps:
1) Calculate the minutes between two dates and times
a. Calculate the difference between two values
b. Use =Round(value,0) to round up to the nearest integer
Multiply by the number of minutes in a day (24*60)
=ROUND((B5-A5)*24*60,0)
2) Convert minutes to hours
a. Divide by the number of minutes in a day “1440”
=C5/1440
Update time format to convert to HH:MM ~ 13:30)