Percentages of Time

[vmed]

Hello all,

I have a requirement to give a % figure from 2 time fields. I would have thought this was simple, but when I divide the fields I keep getting #Error. Its not an error caused by a divide by zero, i can recify those. Can anyone point me in the right direction to get a % from 2 time fields.

Cheers
vmed

 

[boblarson]

What, exactly, are you trying to calculate with? In other words, what does the data look like, how is it stored, and % of what?

 

[RuralGuy]

This link may help to better understand how DateTime fields are stored.
Storing, Calculating, and Comparing Date/Time Data

 

[vmed]

Hi, thanx for taking time to reply.

I am basically trying to work out what % one column is of another in a table. The dat is stored in hh:nn:ss format. I have somehow stumbled upon the answer to my own query. I have in effect added 2 extra columns to my table and stored each column twice, one in hh:nn:ss format, the 2nd in serial format. Then when my report reference the query, anything that is simply a display box, uses the hh:nn:ss column, and anything that needs a formula references the serial columns.

As usual I never learn. I keep meaning to kepp all raw data in its easiest formats, but always end up formatting them way to soon.

Apologises for wasting anyones time, i do appreciate it.

Cheers

 

[boblarson]

No time wasted - it's all good!

 

[The_Doc_Man]

For what it is worth, we all run into that problem. To convert or not to convert, that is the question. Whether 'tis nobler to keep data in its original form, or to despoil it with the vilification of reformatting. Aye, there's the rub. To reformat, perchance to then need to unformat later. And multiple formats are such sweet sorrow.

Must be getting late 'cause I'm getting whacky. I think I'll go shake a spear at someone just to stir up much ado about nothing.