time difference between 2 different time values

G

Guest

Hi
Having trouble figuring this function out, so any help would be great
In cell 1, I have a time in and in cell 2 a time out. In cell 3, I need a total amout of time lasped. Data is enterd in an "7:05 Am" format. And the diffrence can be greater than 12 hours but less than 24
Thank You
Mike
 
F

Frank Kabel

Hi Mike
try
=B1-A1+(B1<A1)
and format the resulting cell as time (this takes also care for times
spanning midnight)
 
G

Guest

Thanks Frank, that was perfect! Feel a little silly for not seeing it for myself
Mike
 

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

Trying to work out the difference in 2 cells. 4
TIME CALCULATION 5
Difference between two date/time values 5
Time difference calculation question 1
If Function With A Time 5
Difference between date and time 7
Time Value Between Two Times 8
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES 1

Top