Time sum

[quinto via AccessMonster.com]

I have a report with 14 calculation of times, 2 per day AM work and PM work
these calculation work fine in short time format, when I try to add them for
the total for the week I get strange totals
I used: =[Text1]+[Text2] etc. what am I doing wrong?

Thanks

Quinto

 

[Allen Browne]

If the total of a date/time field is greater than 24 hours, Access gives you
a date/time value represnting another day. If you display this as Short
Time, you suppress the date part, and see only the hours above a multiple of
24.

Use DateDiff() to get the time value in the mimimum unit you need (probably
minutes.) Details in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[quinto via AccessMonster.com]

This work great but now I need to handle the null spaces for the total
Some employees have AM only, some PM only and some both.

Thanks

Quinto

If the total of a date/time field is greater than 24 hours, Access gives you
a date/time value represnting another day. If you display this as Short
Time, you suppress the date part, and see only the hours above a multiple of
24.

Use DateDiff() to get the time value in the mimimum unit you need (probably
minutes.) Details in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

I have a report with 14 calculation of times, 2 per day AM work and PM work
these calculation work fine in short time format, when I try to add them
for
the total for the week I get strange totals
I used: =[Text1]+[Text2] etc. what am I doing wrong?

 

[Allen Browne]

Looking at your original example, it might be like this:
=Nz([Text1],0) + Nz([Text2] ,0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

This work great but now I need to handle the null spaces for the total
Some employees have AM only, some PM only and some both.

I used: =[Text1]+[Text2] etc.