I suck at math... any ideas???

# Thread: I suck at math... any ideas???

1. Member
Join Date
Dec 1969
Posts
69

## I suck at math... any ideas???

Hi-<BR><BR>I have to do some time-card calculations and the company i&#039;m doing the project for wants the time calculated in a way I don&#039;t know how to accomplish...<BR><BR>Basically, right now I&#039;m calculating the time like this: <BR>TotalTime = (Datediff("n",objRSJ("Start"), objRSJ("Stop")) 60) & ":" & (Datediff("n", objRSJ("Start"), objRSJ("Stop"))Mod 60)<BR><BR>NOW, these people want the time calculated in a percentage, so, 1 hour 15 minutes would be 1.25, 1 hour 30 minutes would be 1.5, 1 hour 45 minutes is 1.75 and so on. Is there an easy way to handle this, rather than defining every minute of every hour?<BR><BR>Thanks!

2. Senior Member
Join Date
Dec 1969
Posts
1,843

## Uhh....

This is pretty basic math, but it&#039;s monday so i&#039;ll let you slide. <BR><BR>Work only with the decimal, not the whole number<BR><BR>15 / 60 = .25<BR>30 / 60 = .5<BR>45 / 60 = .75<BR>37 / 60 = .616<BR>etc etc etc etc etc

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•