Forum Discussion

Lee_Ginny's avatar
Lee_Ginny
Copper Contributor
May 09, 2024
Solved

Formula to calculate response time in hours and minutes

Hi Anyone can suggest the formula to calculate the total time use for a response. Example below: Example 1: Start time: 5/1/2024, 16:19. End time: 5/2/2024, 10:39. Example 2: start time 5/3/2024 9:...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    May 10, 2024

    Lee_Ginny 

    I have adjusted and corrected my function again. I think it should work now. But you would have to extend the list of public holidays for your country. Also, if you want to use this formula commercially, you would have to put it to the test with lots of examples.

     

     

Lee_Ginny's avatar
Lee_Ginny
Copper Contributor
May 10, 2024

HansVogelaar 

 

May I know how can the function move to my workbook? As I try to edit the information from the workbook you shared, the formula will run.

 

https://efinix-my.sharepoint.com/:x:/g/personal/zllee_efinixinc_com/EQOsCmvQKwROka96r_hn0y0Bzyv3fJDaFR4vx5Z2HFagdQ?e=6T2Yyn 

 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 10, 2024

    Lee_Ginny 

    Open both your workbook and my demo workbook.

    Press Alt+F11 to activate the Visual Basic Editor.

    In the Project Explorer pane on the left hand side, expand Modules under my workbook if necessary. You'll see Module1. Drag Module1 to your workbook and drop it there. This will copy the module with the code for the function to your workbook.

Resources