For your purposes, you could calculate the full DATETIME value of the
shift start and end, and then a simple (EndDateTime-StartDateTime) =
Elapsed will give you the elapsed time. Said time will probably be in
seconds, so minor adjustments would be necessary.
Albert
On 2016-03-04 12:11 PM, [email protected] wrote:
I've never had to do this. Would it help if you had 2 computed date
columns that had a DEXTRACT of the start and end? I'm assuming you
have 2 DateTime columns now? Because then if the 2 DEXTRACT columns
are the same then you can simply do math of the time; if not then you
add together 2 times, from beginning to midnight and then from
midnight to end.
Can't think of anything more elegant...
Karen
-----Original Message-----
From: Tom Frederick <[email protected]>
To: karentellef <[email protected]>
Sent: Fri, Mar 4, 2016 12:35 pm
Subject: [RBASE-L] - Midnight shift notes
We have to track activity by shift and write a note for record
purposes. All notes have a staff ID, topic, actual note, date and
start/end times which provides proof of activity. Right now I can bill
activity by a whole day, but a change to billing by the hour is
coming. For day and evening shifts it is pretty easy. They stay same
day and within a consecutive time frame. Overnight shifts have to deal
with Midnight date/time changes to automatically split over two dates
and make 24 hour clock time adjustments. I can check for overlap or
bad start/stop times within the same date. Making adjustments for
Midnight date/time is just not clicking in my head. Any suggestions
are welcome.
Tom Frederick
President/CEO
Elm City Center
1314 W Walnut
Jacksonville, IL 62650
O-217-245-9504
F-217-245-2350
[email protected]
<mailto:[email protected]><mailto:[email protected]
<mailto:[email protected]?>>
