VBA Code to Calculate the Difference Between Two Times in Excel

VBA Code:

' VBA Code to Calculate the Difference Between Two Times in Excel

Sub CalculateTimeDifference()
    Dim startTime As Date
    Dim endTime As Date
    Dim timeDifference As Double
    
    ' Prompt the user to enter the start time
    startTime = InputBox("Enter the start time (HH:MM:SS):")
    
    ' Prompt the user to enter the end time
    endTime = InputBox("Enter the end time (HH:MM:SS):")
    
    ' Calculate the time difference
    timeDifference = endTime - startTime
    
    ' Display the result
    MsgBox "The time difference is: " & Format(timeDifference, "hh:mm:ss")
End Sub


Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment