You’re offline. This is a read only version of the page.
Announcements
23
Hello again,I’m struggling with a DateDiff funciton. I have two dates with hours and minutes values. I want to check how many hours of difference there is and divide it by 24 hours, get a number of days left and spare hours which will be used later on.
DateValue1
HourValue1
MinuteValue1
DateValue2
HourValue2
MinuteValue2
Days between
Share
Report
All responses (
Answers (
RoundDown(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Days),0)
Spare hours
RoundDown(Mod(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Hours), 24),0)
Spare minutes
RoundDown(Mod(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Minutes), 60),0)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
