I have
start time end time work time
17:00 18:00 01:00

Now, I have to convert this 01:00 to 1,00! How?

Work time is calculated on 00:15min parts
so I could have for example:

start time end time work time
17:00 18:15 01:15

And I have to convert it to 1,25

if 01:00h = 1,00
if 00:30min = 0,50
fi 00:15min = 0,25

I round it on 00:15min as smallest unit of hour!

Must have this to sum total number of work time so I can multiply it with
fee per hour... Or is there any formula what can do that directly from the
hour time

If I put work time column to sum all time, when sum is over 24h it starts
again from 0! So if total sum is example 34h it will show 10h or if its 49h
it will show only 1h....

I'll send document if someone doesn't understand what I need?

Thanx in advance

--
"They say people don't believe in heroes any more...
Well damn them!!!... You and me, Max.
We gonna give'm back their heroes!"