adding and subtracting two time

[smahdih]

Dorod

in a query i have four date/time fields,


Date1 formatted yyyy/mm/dd
Time1 formatted short time
Date2 formatted yyyy/mm/dd
Time2 formatted short time

i want in a new field insert ( (Date2 - Date1) + (Time2 - Time1) ) formatted hours

for example :
date1 = 2011/01/05
Date2 = 2011/01/06
Time1= 10:20
Time2 = 20:30

Date1 - Date2 = 24Hours
Time1 - Time2 = 10:10
((Date1-Date2) + (Time1-Time2)) = 34:10

How i can build it?

[June7]

Use DateDiff function http://office.microsoft.com/en-us/ac...001228811.aspx

[smahdih]

Use DateDiff function http://office.microsoft.com/en-us/ac...001228811.aspx

i use datediff , but when adding two time , if plus two time was over 24 hours not display over 24

my query attach

[June7]

If you calculate a full date/time field should work. This is why best to store date/time as one value, not in separate fields. The time needs a valid date part to calculated elapsed hours for period crossing midnight.