It looks like it defineatly has to do with the export having the am/pm in the
number cell,
if i find all am and pm and replace with nothing, in other words remove the
refernce, then excel automatically puts in caps AM - which of course does not
work either. I suspect now it has to be on a 24 hour clock so that excell
can figure that out, i will try this let you know how it works out.
hopefully the software that i am exporting from has this option.


"Glenn" wrote:

Siteman wrote:
i have read and tried all of the threads on calculating time difference but
none of them work.

Specifically
i have done an export of data to excell the times come out like this,
A B C
start end
2:00pm 3:50pm 1 ( i want to round this to the nearest hour)

I formated the above cells h:mm pm
and the formula cell as general with decimals

i have tried =b1-a1
=int((b1-a1)*24)

none of which work, if i delete the pm or am it will calculate, but not
accurately.

I want to round up the time calculation to the nearest number,
ie, 2:00pm 3:50pm 2(hours)

any thoughts?


=ROUNDUP((B1-A1)*24,0)