# Formula in Excel

I want to create a formula to switch 657:58:15 (hr:min:secs) to (day:hr:min) .. excel gives you the option to switch it .. however it doesnt seem to work for such as high number of hrs.

Thank you
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Two solutions...

First assuming you have value in a1..

Then in b1 you can write-->=TEXT(A1,"d:hh:mm")

Soultion-2

If you don't want to change the value but just the display..press ctrl+1 over the a1..then custom and give the formatting-->d:hh:mm

Hit Okay and vola you will see your hh:mm:ss format is changed to the format that you are looking for...

Saurabh...
Author Commented:
hi there,

This is a good start .. however . .. this works only for some values in my spreadsheet ... for example .. for that value works perfectly but I have higher values where the number is incorrect ..

Example: 987 hr/24= 41 days .... and using your formula the value given is 10 hrs ...
Commented:
Use this formula in =INT((A1*24)/24)&":"&INT(MOD(A1*24,24))&":"&MINUTE(A1)

Experts Exchange Solution brought to you by