Time Situation

J

Jafferi

Cell A1 ~ 8:00
Cell A2 ~ 17:00
Cell A3 ~ ABS(A2-A1)=9:00 XXX
How can I formulate that Cell A3 is equal to 8:00 after minusing lunch of 1
hour. I keep on getting ##########
 
P

Per Jessen

Hi

Use this in A3:

=A2-A1-TIMEVALUE("1:00")

Remember to format the cells as time t:mm.

Regards,
Per
 

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

problem with time subtraction 7
Excel - Wich Function should I use? 1
15 minute data to daily data 1
I need Time Range to return Value 4
separating date and time 5
Convert times to text string 3
Time Span calculations 4
Calculate elapsed time excluding specific timeframe 10

Top