I need to calculate total time worked in a period with multiple work days. For each workday I have a start time and a finish time. I have no problem if the time worked is an exact # of hours. But if there should be a fraction of an hour in the total, it is truncated.

I'm using the following calcs to arrive at the daily time worked:

If StartTime > FinishTime Then
myFinish = FinishTime + 1
Else
myFinish = FinishTime
End If
MyHours = DateDiff("h", StartTime, myFinish)

StartTime and FinishTime are provided from input data. Again this function works fine if the time is an even hour. Otherwise, no go.