Problem in negative value when convertin to hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

when I converting a negative value to hours sometimes the convertion is a
wrong.

If I have -2.5 that means -2:30h, it converts to -3:30h, but if I have -8,
it converts to -8:00h

I'm using this querie:
TotalHorasLiquidaGozar: Int([TotalHorasGozar]) &
Format([TotalHorasGozar]/24;":nn")


How can I solve this?

Regards,
Marco
 
Try using Fix instead of Int.

Look up the two functions in the VBA help to see the difference in the
results they return with negative numbers.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thanks: :) it works

John Spencer said:
Try using Fix instead of Int.

Look up the two functions in the VBA help to see the difference in the
results they return with negative numbers.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Hi.

when I converting a negative value to hours sometimes the convertion is a
wrong.

If I have -2.5 that means -2:30h, it converts to -3:30h, but if I have -8,
it converts to -8:00h

I'm using this querie:
TotalHorasLiquidaGozar: Int([TotalHorasGozar]) &
Format([TotalHorasGozar]/24;":nn")


How can I solve this?

Regards,
Marco
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URGENT - How to convert this decimal values into hours? 2
Reallocate array cells value from positive to negative 0
If result is negative then enter 0 5
decimal day to standard hours, help please 3
How to sum negative times 2
Problem with converting Text to Number 3
negative values to be returned as zero 6
How to query a field for Absolute Value in Access 2007 7

Back
Top