how can I add time in excel to determine how long something took?

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

Guest

if I put down 7 am in one column and 4:49 pm in another, what formula do I
use to determine total time (9.81 hours)
 
=(4:49 pm - 7:00 am) * 24

Make sure the times are formatted as times and the calculation is formatted
as a number.

Dave
 
Hi Eric

assuming the 07:00 am is a1 and 04:49 pm on B1

=(b1-a1)*24

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Eric" escreveu:
 
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

Excel Facetime Measurement 1
Determine "on time" status 9
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Extracting just the time portion 5
Convert times to text string 3
how can i add time in excel? 2
calculating time in excel 0
Variable Pay-rate after 5pm 1

Back
Top