Excel: convert time to decimal number, hours, minutes or second…
https://www.ablebits.com/office-addins-blog/excel-convert-time-decimal/
The easiest way to convert time to decimal in Excel is to multiply the original time value by the number of hours, seconds or minutes in a day: To convert time to a number of hours, multiply the time by 24, which is the number of hours in a day. To convert time to minutes, multiply the time by 1440, which is the number of minutes in a day (24*60). To convert time to seconds, multiply the time time by 86400, which is the number of seconds in a day (24*60*60 ).
To convert time to a number of hours, multiply the time by 24, which is the number of hours in a day.
To convert time to minutes, multiply the time by 1440, which is the number of minutes in a day (24*60).
To convert time to seconds, multiply the time time by 86400, which is the number of seconds in a day (24*60*60 ).
DA: 24 PA: 75 MOZ Rank: 41