Hi
just multiply this value with 24 and format the resulting cell as
number

--
Regards
Frank Kabel
Frankfurt, Germany


Mike Torello D.E.A. wrote:
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