Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Mar 23, 2023
Solved

Formula for Wait Time

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 n...
excel
  • NikolinoDE's avatar
    NikolinoDE
    Mar 23, 2023

    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)

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Mar 23, 2023

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)

Resources