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

Time Span calculations 4
Work Hours 1
Convert times to text string 3
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Error in subtracting times 2
Difference between two date/time values 5
Very Simple Time/Hour Question 2
Date/Time 1

Top