Hours & minutes calculation

[Ron99]

Hello,

Working hours = 5 hours
login time = 8:00 am
logout time = 11:15am
I need to calculate the shortage hours and minute. By looking at the login and logout hours are 3:15 attended so the shotage is 1:45 minutes. Is there any formula to get the result only for shortage which is 1:45 using excel.

Thanks

 

[HighAndWilder]

Hello,

Working hours = 5 hours
login time = 8:00 am
logout time = 11:15am
I need to calculate the shortage hours and minute. By looking at the login and logout hours are 3:15 attended so the shotage is 1:45 minutes. Is there any formula to get the result only for shortage which is 1:45 using excel.

Thanks

Hours & minutes calculation.xlsx
	E	F
2	Working Hours	5
3	Login	08:00
4	Logout	11:15
5	Shortage	01:45
Hours

Cell Formulas
Range	Formula
F5	F5	=($F$2/24)-($F$4-$F$3)