Cell format

[richarddy]

how to format, for example elapse time in [ss], to number format? have another cell with rowcount data in number format. i'm trying to compute rowcount per second but the elapse time cell is showing huge number.
thanks for your help.

 

[SimonDavis]

What is the real data you are working on? I did an FAQ on dates+times a while ago, which you'll find in the office FAQ area.

If for example you are using a now() function, you may be working on the date+time, which could indeed be a comparatively large number (like 35,000.xxxx or something)

Alternatively, being pedantic, are you sure it's a large number, and not a very small number? A tiny fraction can be shown in scientific format, which might look like a big one . . .

I guess you're using a start time, stop time, and removing the first from the second? First make sure both numbers are starting from the same relative point.

If you could show how you get the start time, the end time, and your formula for elapsed time, we might be able to spot any problems.

 

[richarddy]

Thanks for your reply.

A1 > Start Time
08/08/2001 12:07:17 AM

B1 > End Time
08/08/2001 12:08:15 AM

C1 > RowCount
319276

D1 > Elapsed Time
Formula=B1-A1
Format Custom [ss]
Data Showing 58

E1 > RowCount/Sec
Formula=C1/D1
Data showing #DIV/0!

My Problem: How to convert Cell D1 (58 in [ss]format) to a number?