Crytstal 2013

[jchewsmith]

I have a start date, start hour and start minutes, then end date, end hour and end minutes that I need to calculate into total hours,minutes worked.

Start Date Start Hour Start Minute EndDate End Hour End Minute Result
4/1/16 8 00 4/1/16 16 15 8.25
4/2/16 8 30 4/2/16 13 00 5.5

Any suggestions on how to bring date time together then calculate total hours worked?

 

[kray4660]

First off you would need a formula to do a date diff (datediff function) get the time difference (I think I would use minutes), then convert back tot hours minutes (several ways to do this). I think this still works
Replace the avgtime with your datediff value.
totext(truncate(avgtime/3600,0),0,"")+":"+totext(truncate(avgtime/60,0)-(truncate(avgtime/3600,0)*60),"00",0,"")

 

[jf111]

Hi,

If you look at the thread I posted recently, I had a similar issue. Some of the formulas there should apply to you as well:

http://www.tek-tips.com/viewthread.cfm?qid=1764023

 

[padytom]

You can also concatenate the start dates and end dates with cdate function to convert to date then subtract based on what datediff you want.