add & subtract time in 1 formula

  • Thread starter Thread starter Mr Chumley
  • Start date Start date
M

Mr Chumley

Trying to set up a flexy sheet in excecl where it adds my start and finish
time in different cells and subtracts my 30min break and give me a total. I
then need to add total times up and if graeter than 37.5 h show me the
overtime. banging head against wall getting no where. Please can someone
Help!!
 
You can use the now() function to return the exact time.
You then have to copy & paste special as values.
You can subtract dates/times, 1 is equivalent to a day in Excel so 8 hours
would be represented as .333333, which you can simply multiply by 24 to
reflect in hours.
 

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

Subtracting time...again 2
Calculating regular time, subtracting any personal time 5
Add/Subtract columns from tab to tab in same file 3
Subtract 1 random no. in col from another without naming cells? 3
how do I create a formula to add up time on a time sheet 3
Adding time with different dates 2
Automatically add and subtract 3
Overtime formulas 14

Back
Top