Jun 06 2019 11:29 AM
Hello. I used to use MS Office in the 80s and 90s and now I'm getting started with 365, doing freelance work. I'm making a spreadsheet to calculate charges for my work, and have gotten a bit confused, after using what I thought was the correct format seen in another post on this forum. The formula I'm using is:
=(TotalTime-INT(TotalTime))*24
to take the total time worked (1:10), but the field shows 4:00 instead of 1.67. What did I miss, to get this erroneous data? (The Help on this subject got me thoroughly confused.)
Thanks in advance,
Rache
Jun 06 2019 11:52 AM
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:
Regards,
Akshay
Tech support | O365CloudExperts
Jun 06 2019 12:00 PM
Solution
Hi,
The result of the formula is correct, but it appears this way because of cell formatting (Time format).
You need to switch to General or Number format like the below screenshot:
Also, you can apply the format in the formula as follows:
=TEXT((A1-INT(A1))*24,"0.00")
I'd like the mention that the formula can be simplified like this:
=TEXT(A1*24,"0.00")
Hope that helps
Jun 07 2019 08:46 PM
Jun 06 2019 12:00 PM
Solution
Hi,
The result of the formula is correct, but it appears this way because of cell formatting (Time format).
You need to switch to General or Number format like the below screenshot:
Also, you can apply the format in the formula as follows:
=TEXT((A1-INT(A1))*24,"0.00")
I'd like the mention that the formula can be simplified like this:
=TEXT(A1*24,"0.00")
Hope that helps