Hi,
I want to calculate time difference between two time fields and display new record with time difference. Below given in the sample record in data base and what is the expected.
Date format is DD/MM/YY
Time is 24 hr format : Ex: 23:45 PM
record present in data base with
Date BeginTime EndTime
28/01/10 23:30 5:30
Output should be
Date Begintime EndTime Hours Minutes
28/01/10 23:30 00:00 00 30
29/01/10 00:00 05:30 05 30
For each record in data base the report should
1.first check the date and begin time.
2.If the begin time is less than 24 hours calculate the difference and display one record
3.and if end time crossed 24 hours(next day)
4.calculate time difference from 24 to end time and display another record
Note: The time is in 24 hour format. User will enter time as 22:15, 11:30 etc
Please let me know if you need more details.