Forum Discussion
Solved
Converting time to a digital number
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...
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
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
Thank you! I suspected it had been something simple, since I used an answer you yourself gave another person! :)