Excel 2013: Convert Hours and Minutes from hh:mm:ss formatted cell in decimal number

Question

I use Excel 2013 and have a cell with the following value:

"08.01.1900 1:45:00"

that will be displayed inside the cell as: "193:45:00" - meaning 193 hours, 45 minutes and 00 seconds (see the first image below).

Here is screen of how it looks like and the formatting of the cell [how it looks like]

QUESTION: How I can in cell "Salary" to get decimal number, like - 193,45? Help me, please.

The cell is formatted as Time (see the image below)

Answer 1

So, you have Q2 = 12:30 (or 12,5 hours where 0,5 hour=30min) and R2 = 15,5 UAH/hour and since you want to calculate salary, you should multiple 12,5*15,5=193,75.
Follow next steps to achieve the desired result:

1. Write next formula in S2: =Q2*24*R2 (since time stored in Excel as part of a day, we need to multimply by 24 . Your value 12:30 is actually 0,520833333333333 ,you can see it if you'd format Q2 as number. Myltiplication 0,520833333333333 by 24 gives you exactly 12,5)
2. Format your S2 as number

the result would be 0,52*24*15,5 = 193,75 and this value is what you actually need.