Formula for how many minutes over time elapsed
Hi, new user and poster. I'm brand new to Excel but trying to learn.I am trying to create a formula to figure out how many minutes over 6 hours something is. So for example A1=Time in, B1=Time Out, and C1=Time Over 6 Hours In Minutes
Thanks in advance.
With A1, B1 is real time, i.e, 8:00, 15:00
Try:
=MAX(0,B1-A1+(B1<A1)-6/24)
With A1, B1 indicates time as integer, i.e, 8, 15
Try:
=MAX(0,B1-A1+(B1<A1)-6)
B1<A1 to add up 24 hours if B1 past midnight, i.e, start: 7:00 PM , end: 2:00 AM,
result should be 2/24 - 19/24 + 1 = 7/24 then minus 6/24 = 1/24 = 1 hour
Quang PT
Thank you for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks