Originally Posted by
jakester
instead of using 1440 in the denominator, plug in the amount of hours in minutes that you are looking to evaluate
for example, if the workweek you are considering has 40 hours in it, multiply 60 minutes by (5*24) to get 7200. Plug 7200 into the denominator and you'll get the answer in hours you are considering.
It's early in the morning so I might be taking you the wrong way... but...
(`Total_Hours`-(`Break_Time` + `Lunch_Time`))/1440 As RHours
'is originally in minutes'
EG: ( 480 -(15+30))/1440
And I am trying to convert it to hh:mm with the option of getting a calculation > 24:00 for calculating a whole weeks worth of minutes...
Thank you for replying though, I appreciate it.