Formula for Wait Time

[Phishdawg]

I need a column that contains the wait time based on 'OutTime' (F2) minus 'InTime' (D2).

Will the following reliably work. I can see the results, and they look true. Just want to make sure...I'm not an Excel person.

=TEXT(F2 - D2,"hh.mm.ss")

[#2 · Accepted solution]

@Phishdawg 

If you want to get the wait time in decimal hours or minutes, you need to use a different formula.

For example, if you want to get the wait time in decimal hours, you can use this formula:

=(F2-D2)*24

If you want to get the wait time in decimal minutes, you can use this formula:

=(F2-D2)2460

You can also format the cells as Number or General to see the decimal values.

For more information on how to calculate time in Excel, you can refer to these web pages:

1. Calculate time in Excel: time difference, add, subtract and sum times 
2. Calculate the difference between two times

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)