time sheet calc by time in and out

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

Guest

Can you calculate total hours by entering the start and finish time? For
example, can you enter 11:30a.m. as the start time and 4:00p.m. as the finish
time and get 4.5 as the calculated answer. If excel can calculate this
figure, then, what format should the cells be in--in order to be able to
enter simply 12 to get 12:00 or 845 to get 8:45. Is any of this possible?
Thanks
 
If A1 contains 8:00 am and B1 contains 4:00 pm...
=(B1-A1)*24
will give you 8 hours.
HTH,
 
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

Time Calc 5
Calculate elapsed time excluding specific timeframe 10
over time in a sheet 2
Converting time to decimal 4
TIME CALCULATION 5
separating date and time 5
display time in 12 hour format 1
time calculation for airline standby 5

Back
Top