Forum Discussion
How to convert hh:mm:ss to 6 hour working day and minutes in excel?
Hi there, I work part time and keep a record of any extra hours I do over above my 30 hours a week. I record these in an hh:mm:ss format and have an accumlulated total in the same format. What I now...
trinakell Not sure what you are trying to achieve. Let's say you have accumulated 21 hours extra time. That would represent 3.5 6-hour working days. And you want this to be displayed as 3 days and 180 minutes?
If so, that could be:
=INT(A1/6)&" days "&TEXT(MOD(A1/6,1)*6/24,"[m]")&" minutes"where the accumulated extra hours are in A1.
trinakell Not sure what you are trying to achieve. Let's say you have accumulated 21 hours extra time. That would represent 3.5 6-hour working days. And you want this to be displayed as 3 days and 180 minutes?
If so, that could be:
=INT(A1/6)&" days "&TEXT(MOD(A1/6,1)*6/24,"[m]")&" minutes"where the accumulated extra hours are in A1.
Riny_van_Eekelen yes that's exactly it! Thank you! Or show as 3 days and 3 hours 🙂 I will try the formula now! 🙂
