Excel Excel 2003 Calculating hours between two dates/times Pls HELP!!!

Joined
Jun 17, 2009
Messages
1
Reaction score
0
This is my first time posting so please bear with me...

I have a spreadsheet with two columns containing date and time stamps and I need to calculate the hours elapsed between the two date/times excluding weekdays and holidays. I tried using the NETWORKDAYS formula but it only considered the dates and reported the results in days, but what I need is hours. Not business hours, just hours. So for example:

Column F Row 7 shows 5/18/2009 21:01

Column G Row 7 shows 5/20/2009 22:27

I need a formula that will consider date and time in each column and report the time elapsed in hours.

Any help or advice on composing my formula would be greatly appreciated!
 
Joined
Jan 29, 2009
Messages
2
Reaction score
0
I have used this to calc from one day to another -
eg - 22.30 --> 01.00 next day

where I2 = 22.30 & I3= 01.00
=I3+(I2>I3)-I2 (this gives a total of 02.30 hrs)

its a start!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top