Still get an error message
"Ryan Poth" wrote in message
...
Mark,
Depending on whether you want to round or truncate to the number of whole
hours, use one of the following in cell C1:

=ROUND((A2-A1)*24,0)
or
=INT((A2-A1)*24)

HTH,
Ryan

"MWH" wrote:

I'm trying to perform a date calc to produce a variance in hours
ex cell A1 3/27/2006 2100, cell B1 3/28/2006 0100, cell C1 =b1-a1,
results I
would like to see is 4
This spreadsheet will be used for scheduling so both positive and
negative
numbers will be used for variance numbers.


--
Mark W. Hanford