Adding Time

  • Thread starter Thread starter Kyle Sweeney
  • Start date Start date
K

Kyle Sweeney

Can anyone help me with this.

I want to add 2 cells time (military time) and convert it to hours. This is
for a payroll system. Saying we are using the following setup:

A1= 0600
A2= 1800
A3= ????

Where A3 is the total hours worked

Thanks
 
Hi!

If you enter the time as true Excel time:

A1 = 6:00
A2 = 18:00

=A2-A1+(A2<A1)

Format the cell as [h]:mm for a result of 12:00

=(A2-A1+(A2<A1))*24

Format the cell as GENERAL for a result of 12

Biff
 

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

Elapsed Time Formula 6
Help Creating Excel Formula 4
Working with Time in formulas/calculations 2
Time Situation 1
Date/Time concatenation 4
Time function =Now formula 4
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
total Hours Worked for week PS thx for the formulars everyone! 1

Back
Top