Hi, I am trying to convert accumulated personal time off (PTO) and all the formulas seem to deal with only 24 hours. I have 32.62 accrued time and need to convert it to 32 hours and 37? minutes I need a formula to do this the 32.62 is in cell G3 and I need the conversion to be in cell H3.
How about this :
=INT(G3)&" hours "&ROUND((G3-INT(G3))*60,0)&" minutes"
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Works great thanks
You are welcome
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
thanks for the help, it will allow me to give the employees a quick answer to how much time they have with out having to wait while I convert it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks