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.
 
Back
Top