kbsudhir
10-20-2008, 02:49 PM
Hello All,
I have a table named "DaysLate" it contains data like "6.04789259"
Here the whole number "6" is the number of days lates whereas the data in decimals ".04789259" represents fraction of days late.
I have convert the data in ".04789259" into hours, mins & secs into three diffrent columns lets say "Hours", "Mins" & "Secs" & the whole number i.e. number before decimal "." to a column named "NoOfDays". I have inserted necessary columns in the same table.
I have to mutiply the faction of the day represented by the data fater the decimal i.e ".04789259" by 9 as we work for 9Hrs a day.
Please guide.
Thanks
Sudhir
:help :banghead:
I have a table named "DaysLate" it contains data like "6.04789259"
Here the whole number "6" is the number of days lates whereas the data in decimals ".04789259" represents fraction of days late.
I have convert the data in ".04789259" into hours, mins & secs into three diffrent columns lets say "Hours", "Mins" & "Secs" & the whole number i.e. number before decimal "." to a column named "NoOfDays". I have inserted necessary columns in the same table.
I have to mutiply the faction of the day represented by the data fater the decimal i.e ".04789259" by 9 as we work for 9Hrs a day.
Please guide.
Thanks
Sudhir
:help :banghead: