Here’s a test file that will show how to do this. It works, but you will have to modify it if the time span is 24 hrs or more. Copy this into a text file and run it at the R>
------------------------------------------------------------------------------------ CLEAR VAR vdatetime1, vdatetime2, vElapsed1, vElapsed2 SET VAR vDateTime1 = (.#now - 85000) -- a little less than a day earlier SET VAR vDateTime2 = (.#now) -- than this datetime (24h = 86,400 sec) SET VAR vElapsed1 = (.vDateTime2-.vDateTime1) SET VAR vElapsed2 = (RTIME(0,0,.vElapsed1)) PAUSE 2 USING .vElapsed2 RETURN ------------------------------------------------------------------------------------ > On Jan 12, 2018, at 7:10 PM, dkfowler6179 <[email protected]> wrote: > > I've been able to get elapsed time between a start and end time as a real > number. Need to get this to HH:MM format though. Columns ckin and ckout are > datetime format (as time sometimes span from one day to the next). I'm sure > this is something pretty simple, but I haven't been able to figure it out. > > Thanks for any help. > David Fowler > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
