How can i enter value in a Time field which is more than 24 hours

[rameshmeena]

I have one field in my Data base called " Totaltime" which is used to enter the total hours required to finish cutting works. Each cutting works time will be different . I cant enter the cutting time which is more than 23:59 hours. some time the cutting time will be 36 hours etcc. Also i need a report by end of every week to sum of the cutting time, to know how many hours the machine worked. But the total of "Totaltime" field is not showing the value more than 23.59 hrs. so please suggest me a solution to solve this issue,

Need your support badly


Ramesh

[CJ_London]

a time field is stored as a decimal number - the date is before the decimal point and the time is after the decimal point and expressed as a percentage of the number of seconds in the day (86400) and now (09:49) would be .409224537 - so can never be greater than 1.

36 hours would be 1.5 (i.e. 1 day, 12 hours).

As to the solution, depends on what users can enter for cutting time. If it is always a round number of hours, then suggest you change the cutting time field to a double so users would enter 36. You can then add this to the cutting start time to determine the end time by using the formula

endtime=starttime+(cuttingtime*3600/86400)

or

endtime=dateadd("h",cuttingtime,starttime)

[rameshmeena]

thank you very much for your reply. Can you please check the sample database. and show me how can i do this.

Regards

Ra,esj

[Bulzie]

Use Numeric datatype instead of datetime for Totatime? Maybe input format to use 2 decimals ##.##. Or use 2 fields, one for hours and one for minutes. At the end you could divide the total minutes by 60 to get the hours and add that to the main hours total?

[CJ_London]

Can you please check the sample database. and show me how can i do this.

sorry, don't have time and anyway you have not said what units of time (hours or hours and minutes). Perhaps Bulzie has time?

[John_G]

For the data you want to capture, you cannot use a Date/Time type. A Date/time represents only a specific point in time - it cannot be used to capture an amount of time, e.g. how many hours/days/.. etc.

As Bulzie has suggested, change the data type to single or double, which you can use to store decimal hours.

[rameshmeena]

For the data you want to capture, you cannot use a Date/Time type. A Date/time represents only a specific point in time - it cannot be used to capture an amount of time, e.g. how many hours/days/.. etc.

As Bulzie has suggested, change the data type to single or double, which you can use to store decimal hours.

thank you very much.. The problem is solved as per suggestion of Bulzie.