Convert number into hours in minutes

[Excel_learner_MIS]

example


In Time 8:00 AM --A
Out Time 3:00 PM --B
formula 24*-(A-B)
Answer 7.00 how do I convert this number into hours and minutes.

 

[etaf]

Re: how do i convert number into hours in minutes

B1-A1
formatted as time - should work

your formula should not work - as thats a negative time (A-B)