User Profile
trinakell
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
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 want to do is convert the accumulated total into hh:mm but for a 6 hour day so I know how many days and mins I am owed in lieu. I've used the formula =FLOOR(O4*24/6,1) where O4 is my accumulated hours however it only gives me whole days. This is ok but would prefer to ve able to see it in days and mins if that's possible, and also now curious to see how it could be done! I had originally found this formula =FLOOR(O4*3,1)&" Days and "&TEXT(SUM(O4,-TIME(8,0,0)*FLOOR(O4*3,1))," h") & " Hours " & MINUTE(O4) & " Minutes "& SECOND(O4) & " Seconds" - but realised (I think!) it was calculating for an 8 hour day and despite playing around with it I am not good enough to figure out how to manipulate it to work for me for a 6 hour day! ALl help/ advice/ suggestions gratefully received - I am a novice at this so please bear with me 😉Solved3.6KViews0likes3Comments
Groups
Recent Blog Articles
No content to show