time in man-day

[lukaspuschner]

Hello, i have the following problem.

I have a field with time values and i have to get the man-days out of it. For example:

08:00:00 should be 1

01:00:00 should be 0,125

can you help me how to get this?

[robert_mika]

If that only first two numbers will be taken into account:

=LEFT('01:00:00',2)/8

[lukaspuschner · Accepted solution]

sorry, that wasn 't the problem, but the question wasn t exact enough.

I solved it by my self. Thank you