Solved Excel Function - Why does it show minutes?

June 1, 2014 at 20:59:29
Specs: Windows XP
Hello,

I am using =INT(AG1-AI1)&" Days "&MOD(AG1-AI1,1)*24&" Hours" and it give me 92 Days 1.99416648008628 Hours, how will I omit the minutes (.99416648008628)


See More: Excel Function - Why does it show minutes?

Report •


#1
June 2, 2014 at 08:58:20
✔ Best Answer
Omit the minutes?

Unless I am misunderstanding what you are trying to do, why not just use INT again?

=INT(AG1-AI1)&" Days "& INT (MOD(AG1-AI1,1)*24)&" Hours"

The first INT only applies to the first (AG1-AI1)

You could also use ROUND, ROUNDUP, ROUNDDOWN, etc. depending on how you want to deal with the decimal portion.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 2, 2014 at 17:58:41
Awesome! It works. Thank you so much!

Report •

#3
June 20, 2014 at 07:06:32
Hello,

I need again your help. :) I need to update this formula =INT(AG1-AI1)&" Days "& INT (MOD(AG1-AI1,1)*24)&" Hours" to exclude Saturday and Sunday.

Please help.


Report •

Related Solutions

#4
June 20, 2014 at 09:16:05
Please start a new thread with your new question. Feel free to include a link back to this thread if you want, but since it's marked as Solved based on the original question about the minutes, your new question deserves its own thread.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question