Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
noff73
Posted - 11/22/2006 : 06:07:21 AM Hi! I think my question is pretty simple but I still struggle to solve it:( So, I am calculating the experimental data in my beta-galactosidase assay. I have one column (say, ColB), which has the time format (mm:ss). ColumnC has some numerical values (optical density of samples at 420nm). For estimating the activity I have to do the division procedure: ColC/ColB. But whenever I am doing that - I am getting some weird numbers (f.ex. 0,436 / 24:45 - the result is 25.3673)... - Could you tell me, please, what can be wrong? - Or, as alternative, is there any simple way for converting my original time format (mm:ss) into secunds only?
Sincerely, Ilya
2 L A T E S T R E P L I E S (Newest First)
noff73
Posted - 11/22/2006 : 11:01:09 AM Thank You very much:) Ilya
Mike Buess
Posted - 11/22/2006 : 08:42:26 AM Cells of date columns are Julian dates with unit equal to number of seconds per day = 87840. Therefore 24:45 is really 0.0171875 and 0.436/0.0171875 = 25.3673. If you want to divide by seconds use ColC/(ColB*87840)