How do I format cells and enter data to be valued for TIME and th.

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

Guest

I need to calculate the difference between 2 or 3 times. Example: Start 9am,
Finish 6pm - how do i format the cells, enter the data in the cells and
calculate the difference to give me a result in time?
 
2
Enter time as 9:00 AM and 6:00 pm in say B2 and c2 and use the formula

=b2-c2-0.041667. this assumes a one hour lunch break

Same fomula works for time entered in 24 hour format. e.g. 9:00 and 18:00

regards
Peter
 
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

Help with time conversions 4
How enter time DURATIONS mm:ss (not clock times), then sum? 1
Calculating business hours between start and stop time 3
Calculate elapsed time excluding specific timeframe 10
Why won't target cell data changes trigger formula evaluation? 3
Difference between 2 dates&time(format 0000), and excludes weekend 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Use custom [mm] formated value that is displayed in a calculation 4

Back
Top