| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Try this:
=INT(A1/7.5)&" Days, "&INT(MOD(A1,7.5))&" Hours, "&(MOD(A1,7.5)-INT(MOD(A1,7.5)))*60&" Minutes" -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "L_n_da" wrote in message ... Staff leave is allocated in hours. One working day is 7:30. Therefore eg 30 hours is 4 days. How do I convert eg 188 hours to days:hours:minutes? Thank you N Harkawat and Ron Rosenfeld for your excellent replies to my previous question. Hope you can help on this one. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Threaded Mode
