[AccessD] datediff & format

Stuart McLachlan stuart at lexacorp.com.pg
Fri May 26 04:50:49 CDT 2017


Is it always within a single day?
or
Can it roll over midnight?  i.e. Can TimeIn be greater than TimeOut?
Can it exceed 24 hours?  If so, do you want 1:02:30 or 26:30 ?

-- 
Stuart


On 26 May 2017 at 11:55, Kostas Konstantinidis wrote:

> Hi all,
> In a time tracking I use the datediff 
> hours: (DateDiff("";[TimeIn];[TimeOut]))/60
> 
> but what I really need is to track the time difference result in
> format as hh:mm
> 
> Could anyone help please?
> Thanks
> /kostas
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list