kohbengleong
New member
- Local time
- Today, 09:01
- Joined
- Dec 23, 2009
- Messages
- 2
Hi Anyone who can help me,
I need to have a field that returns the difference between the [Closed Date and Time] and the [Created Date and Time]. Then the difference will be in the format of hhhh:nn:ss. That means if the difference is more then 1000hours it will show in hours, mins and secs instead of months, days, hours, mins and seconds.
I did a query which returns TimeDif by using:
TimeDif: ([Closed Date and Time]-[Created Date and Time]) but i am not sure how to change the format of the field TimeDif to the one i want which is in hours mins and secs. As shown in the file i attached, the TimeDif is in decimal form. Which i later learnt from some of the posts is that the numbers before the decimal point actually refers to the days and months and the numbers after the decimal point refers to the hours mins and seconds. Please correct me if i am wrong.
My question here is that how can i create this field which will return to me the date time difference in just hours mins and secs? I had no problem with this in excel as i could custom format to [h]:mm:ss. But for Access i still have not found any clue so far.
The data i got stems from Oracle CRM on Demand.
Will apreciate a lot if someone can help me out here.
I need to have a field that returns the difference between the [Closed Date and Time] and the [Created Date and Time]. Then the difference will be in the format of hhhh:nn:ss. That means if the difference is more then 1000hours it will show in hours, mins and secs instead of months, days, hours, mins and seconds.
I did a query which returns TimeDif by using:
TimeDif: ([Closed Date and Time]-[Created Date and Time]) but i am not sure how to change the format of the field TimeDif to the one i want which is in hours mins and secs. As shown in the file i attached, the TimeDif is in decimal form. Which i later learnt from some of the posts is that the numbers before the decimal point actually refers to the days and months and the numbers after the decimal point refers to the hours mins and seconds. Please correct me if i am wrong.
My question here is that how can i create this field which will return to me the date time difference in just hours mins and secs? I had no problem with this in excel as i could custom format to [h]:mm:ss. But for Access i still have not found any clue so far.
The data i got stems from Oracle CRM on Demand.
Will apreciate a lot if someone can help me out here.