adding up dates and times 1

[seabubble]

Hi, Can anyone help ?
I have a formula that converts Remedy time to normal time.

DateAdd ("s", {HPD_HelpDesk.Create_Time} + 3600, #1/1/1970#)

I have two columns

Create date time Close Date Time hh:mm
01/10/2004 12:00 01/10/2004 13:20 1:20
01/10/2004 13:00 01/10/2004 14:10 1:10
Total hours and minutes 2:30

I would like to know the formula for subtracting create time from close time to get the hh:mm then total them up into rounded hours

I have the white papers for business hours which I am reading at the moment (hard going)!

 

[Madawc]

First, get @MinutesDiff

DateDiff ("n", @Createdatetime, Close Date Time)

This gives you the minutes, "n" is minutes because "m" is months. Then get @HourMinDiff

Round(@MinutesDiff/60)

Madawc Williams (East Anglia, UK)

 

[seabubble]

Thanks Madawc. Works a treat!