Overlaping Hours

  • Thread starter Thread starter scotty
  • Start date Start date
S

scotty

is there any way to calculate time over multipe days?? Or
less than a day? So that whena date changes it adds 24
hours to your 24, and so that it adds the total number of
hours correctly at the end of the month. Someone who is
good with excel please e-mail so I can explain better.

scott
 
Hi Scotty!

Just include the date component in your times.

A1
23-Jun-2004 10:00
B1
27-Jun-2004 18:30

=B1-A1
Format [hh]:mm
Returns: 104:30
 
Hey Norm

I tried doing exactly what you said and it still didn't
work. I get a value error and I've tried to correct it
several different ways and it isn't working. Do you have
any other suggestions?
 
Back
Top