DateDiff

[jesse123]

I’m trying to find the difference between two times.

This is what I have...

<%=DateDiff("n",(RS_Tickets.Fields.Item("FLD_TimeStart").Value),(RS_Tickets.Fields.Item("FLD_TimeEnd").Value))%>

Is it possible to make it so it displays the difference in HH:MM format?

The way it is now, it shows the minutes.(show 01:30 instead of 90)

 

[Sheco]

I made a simple ASP like this:

<%
Response.Write FormatDateTime(CDate("2:00pm") - CDate("12:30pm"), 4)   
%>

The output was "01:30"

 

[jesse123]

Just what I needed.

THANKS!