[AccessD] datediff & format

Kostas Konstantinidis kost36 at otenet.gr
Fri May 26 05:05:32 CDT 2017


Hi Stuart,
I guess I need both of them while I need extra calculation for weekly and
monthly sum

Thanks
/kostas

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Friday, May 26, 2017 12:51 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] datediff & format

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



-- 
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