Time on Road calculation help

[Anupam9]

Hello all,
Need help to calculate total time (in hours) spent each day on road from total working hours in a day!
I have total distance covered per month which is 3500 miles
Speed is 40 miles per hours
Daily total work hours are 8

I would like to find out how many hours my employees are spending on road every working day ( 8hrs working shift)


Thank you

 

[Georgiboy]

A simple calculation might be:

Book1
	A	B
1	Miles	3500
2	Speed	40
3	Hours	87.5
4	Working days in a month	20
5	Average driving hours per shift	04:22:30
Sheet1

Cell Formulas
Range	Formula
B3	B3	=B1/B2
B5	B5	=(B3/B4)/24

 

[Anupam9]

Thank you