Calculate the correct time difference

[mukeshbaviskar]

Hello Friends,
In this attached file I want the result of time difference correctly to get proper result. I want to calculate the honorarium of lecturer in rupees.
The time difference shows 1.30 instead of 1.5 which gives me wrong result.

If the difference is 1.30 hours then the honorarium must be hours times rate.
1.30 * 200 = 300 but I'm not getting this result. For it the time difference must be 1.5 instead of 1.30. How to tackle this problem?
Thank you.

Mukesh Baviskar
Mobile: 9403161157

[benishiryo]

hi Mukesh. Excel treats time as decimals. so 12 pm (half a day) is actually 0.5 if you format it as General. if you want to show Column H as decimals like 1.5, then:
=(G7-F7)*24
format as General

if you want it to show as 1:30 still but calculate as 1.5 in Column J, then in J7:
=H7*24*I7

[mukeshbaviskar]

Hello benishiryo,
Thank you very much. Now my problem is solved.

Mukesh
Mobile: 919403161157