turn working hours into man.days

  • Thread starter Thread starter Alain R.
  • Start date Start date
A

Alain R.

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.
 
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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top