Subtracting Time can it be done with a fx?

G

Guest

I have a co-worker that is trying to create a spreadsheet to keep track of
how many minutes it takes to complete drafting projects. He wants to be able
to enter his start time in one cell, his finish time in another cell and be
able to get a result of how much time it took in minutes or hours in another
cell. For example, he starts and enters in a cell 2:00p.m. then in the next
cell he finished at 3:30p.m. he wants a result cell to show 90 minutes. Of if
he uses military time he wants the same results. Is there a function that
will calculate time like this?
 
G

Guest

Try

=(B1-A1)*24

Where A1 is start (earlier time) and B1 is end
Format as general

Mike
 
D

David Biddulph

=(B1-A1)*24*60
Note that the time should be entered as "2:00 pm", not "2:00p.m.". 14:00 is
O.K.
 
J

Jon Peltier

You can put =B2-B1 in a cell to compute the difference, then use formatting
to display it however you want.

[m] will show just minutes even if it goes over an hour, while h:mm will
show hours and minutes, or use [h]:mm to show hours even if it goes over one
day.

- Jon
 

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

Top