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

"tpayne" wrote in message
...
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?