Hello,
Some of the reports received from technicians are reading 1645 (minutes worked on a ticket), however for the reporting purpose I will like to display 1 day 3 hours 25 minutes in my excel report.
Do I need to use a formula or a macro?
Thank you for your feedback and help.
=a1/1440
format cell as: d "days", h "hours" mm "minutes"
Hi, I like mama's answer better than mine but..
With 1645 in cell A2
Days = =INT(A2/(60*24))
Hours = =INT(MOD(A2,24*60)/60)
Minutes = =MOD(A2,60)
I still like TM answer better than mine.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
hi bandera, would it ever exceed 31 days? the formatting of cells wont work if so. mine is the same as MarvinP:
=INT(A1/1440)&" day/s "&INT(MOD(A1,1440)/60)&" hour/s "&MOD(A1,60)&" minute/s"
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I would just use =A1/1440 and format as [h]:mm to see 27:25. That way the result can be used in a downstream calculation.
Entia non sunt multiplicanda sine necessitate
Thank you everyone. Mama's solution did the trick for me.
You're Welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks