Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a cell contains 7A-3P (Day shift). Is there a way to calulate the total
hours in another cell?

Thank you,

Paul

I am a new guy
 
Use real times instead of text and put them in separate cells

07:00 AM in A1
03:00 PM in B1


=B1-A1
 
Peo,

Thank you for answering so soon. My supervivor does not want to change
current layout of schedule. I like your way but not able to use it. is there
another way?

Paul
 
Tell her/him he's an idiot!

=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("-",A1)+1,2),"A",":00 AM"),"P",":00
PM")-SUBSTITUTE(SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),"A",":00 AM"),"P",":00
PM")

if you want it as an integer use

=24*(SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("-",A1)+1,2),"A",":00 AM"),"P",":00
PM")-SUBSTITUTE(SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),"A",":00 AM"),"P",":00
PM"))
 
I agree, he is an idiot. Thanks for the help. I will let you know how things
work out.


Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please Help with this formula...Thanks 7
comparing time value 4
Skip over 1st number and locate 2nd - ? 2
How to make a Formula containing times. 7
How to create identical dropdown lists in large blocks of cells 2
product code a value 0
Calculating Staffing on a Schedule 7
Icon sets fomatting error 0

Back
Top