date prob!

[nicola1]

Hi all,

I have two date and time fields which format are like: 15/09/05 09:48:43,I have another field which calculates the time difference between these two fields. I am doing a calculation on the time difference field and want the time to be displayed as for example 03:00, but at the moment it just shows 3:00.

This is the control source which has some formatting in it:

=Int(CSng((([txtDateDel]-[txtdateRO])-[closed])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")

I have tried adjusting this but am having no luck.

I would be grateful of any help,

Thanks

 

[reclusivemonkey]

Table, query or report? You are only getting "3" as you are simply looking for an integer; you can get 03:00 simply by formatting the field to time type.