times calculation

[Ron]

I will try make this short. I work in Public Safety,
Fire Dept. I need to be able to calculate our times and
average as well. Example of what I need is

a b c d e
03:14:20 03:16:20 03:20:20 03:30:20 03 34:20

f
03:50:00
Sorry about the column. I need to calculate the time
between each of these. I know the simple thing, but
conditional is a problem. I know very little about excel
in regard to macro, or programming anything.

Column A is time dispatche and Column B is time I said I
am going. We call this our prepare time. B1-A1 =
prepare. I got that all the way across. i also know to
=B2-A2+IF(A2>B2,1) put this in for across midnight.

Where can I find some help on if time not there. Example
if the prepare time I check enroute is not put in by a
dispatcher, then it will be blank or null. So I get a
lot of pound signs after my formula. I need to know what
or how to set some if statement maybe, I do not know.
Each of these times across are subtracted to give me
prepare time, travel time, on scene time, ambulance
transport time, ambulance at hospital time, and time
involved on the call. so I do calculation on all the
time. And it is different if the unit is a Fire Enging
or a Ambulance. Thanks in advance for any help.

 

[Matthew Connor]

I will try make this short. I work in Public Safety,
Fire Dept. I need to be able to calculate our times and
average as well. Example of what I need is

Column A is time dispatche and Column B is time I said I
am going. We call this our prepare time. B1-A1 =
prepare. I got that all the way across. i also know to
=B2-A2+IF(A2>B2,1) put this in for across midnight.

Where can I find some help on if time not there. Example
if the prepare time I check enroute is not put in by a
dispatcher, then it will be blank or null. So I get a
lot of pound signs after my formula. I need to know what
or how to set some if statement maybe, I do not know.

<snipped>
You might get a lot of help from the more usage of the IF statement.
You can do something like (for prepare time):

=IF(B1<>"",B1-A2+IF(A1>B1,1),"No Going Time")

B1<>"" will determine if the cell has any value in it. There are some
other way do do similar things - ISBLANK(B1), ISNUMBER(B1).


Hope this helps,

Matthew

 

[Bob Phillips]

Ron,

I think you would do well to spend some time reading Chips Pearson's web
page on time, http://www.cpearson.com/excel/datetime.htm#WorkHours, I think
you will find it repays you by giving you the understanding that you seek.