Any Excel Gurus?

[Matt Newman]

I rarely use Excel but I need to know if there is a formula that will take two times or and subtract the two to get the number of hours/minutes between them. Like if I input 1:00pm and 5:00pm I would get 4. Does this exists?

-Matt Newman

[Lost User]

You could use TIMEVALUE. =(TIMEVALUE("5:00 pm")-TIMEVALUE("1:00 pm"))*24 returns 4. Cheers, Drew.

[Matt Newman]

Thanks a lot, I think that deserves a free adult beverage should our paths ever cross :)

-Matt Newman

[Lost User]

Matt Newman wrote:

I think that deserves a free adult beverage should our paths ever cross

Oooh, I think I'll take you up on that! Cheers, Drew.

[Ed Gadziemski]

Matt Newman wrote:

free adult beverage

Milk! Yum!

[Lost User]

Tea?

Visit http://www.readytogiveup.com/[^] and do something special today.

[PIEBALDconsult]

Sounds like mature Scotch to me.