Convert Formula result in Time Format

Can somebody tell me how to do this? I have Total tonnage and crane capacity if i divide this i get the handling rate but this handling rate i wnat it time format E.g. total tonnage 2000 handling rate 1500 tonnes/hr the mathamatical result is 1.33 hours but i want this 1.33 hours in Time format. plase also let me know how to convert 0.25 in 0.15 hours?

Hi,
divide the result by 24 and format as time

Cheers

Thanks,

But please also let me know how can i enter 15 minutes time in cell what formatting i have t do?

You can enter "0:15" without the quotes.
Cheers

Thanks, you have solved y major problem

Thx for the feedback.This link will provide more insight about how XL works with date and time