Jun 06 201911: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
Labels: