Hi,
in our company, standard working time is 07:30 (or 7.5) hours per day.
i would like to know can i convert working hours during month as man.days ?
e.g.: if someone worked 15 hours = 2 man.days.
format of cells where daily hours are written is : hh:mm:ss
and i want to get something like dd.hh.mm as resulting man.days
thanks a lot,
A.
Bob Phillips - 03 Mar 2008 10:25 GMT
Assuming the total hours are in A1, use
=INT(A1*24/7.5)+MOD(A1*24,7.5)/24
and format the cell as d:hh:mm

Signature
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> Hi,
>
[quoted text clipped - 9 lines]
>
> A.