Military Time IF Then Range

N

NedG

Need to Look at a Military time entry and then compare with a Low and High
entry then Average with other cells
 
F

Fred Smith

You're not getting any responses, because you haven't provided enough
detail.

To Excel, times are numbers (fractions of a day). It doesn't matter how they
are formatted (military, am/pm, etc.).

If your time is in A1, your Low is in A2 and High in A3, you might be
looking for something like:
=if(and(a1>a2,a1<a3),average(b1:b6),"")

If that doesn't help, post back with more information.

Regards,
Fred.
 

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


Top