calculate hours between two dates in text format

Like (0) Share

Report

Posted on 2 Apr 2022 08:28:54 by Community Power Pla...

Hi everybody. I need to calculate hours between two dates from a text label. What i tried is giving me 6 hours as a result.

Here´s what i spect:

StartDate: 20/02/2022 23:00

EndDate: 21/02/2022 04:30

Total Hours: 5 hours

This is what i tried:

"Total Hours: " & DateDiff(DateTimeValue(start_date_label.Text); DateTimeValue(end_date_label.Text);Hours)

Any help will be much appreciated.

All responses (5)

Answers (1)