Convert number into hours in minutes

Excel_learner_MIS

New Member
Joined
Apr 16, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,592
Office Version
365
Platform
MacOS
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,089,850
Messages
5,410,747
Members
403,328
Latest member
dalan

This Week's Hot Topics

Top