Calculating Hours if more than 24....

[stlrain95]

I am trying to calculate Cycle Time for my warehouse.

I am using a start time & End Time to calculate

The format is MM/DD/YYYY H:MM I would like to get the actual hours from this. But, a simple calculation doesn't give me anything more than 24 hours.

Can this be done??

 

[SgtJarrow]

Check out the DateDiff function....you can have it return values such as hours between times, days or whatever...

****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[stlrain95]

I have looked this up in Excel and the Excel help with nothing? I looked this up under the Date/Time Function.

Please provide something more specific. Much appreciated.

 

[SkipVought]

Hi,

If you take the Date/Time DIFFERENCE and format the cell...

[h]:mm:ss

it will be in hours, min, sec

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

If you want pure hours, take the difference and multiply by 24 hr/day since Excel/Access store Date/Time in days.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[stlrain95]

Works fantastic...now for a little more in depth question. If I only work 12 of the 24 hours....how do I now reflect the REAL time?

Thank you again for the help.

 

[bluedragon2]

Divide the function by 2



Blue

If I wasn't Blue, I would just be a Dragon...

 

[stlrain95]

Easy enough!! Thanks again for the great input