Full Version: Sum Hours - More then 24
UtterAccess Forums > Microsoft® Access > Access Date + Time
I have a form wich shows multiple rows of a sum of hours. Most of them pass 24 and I want them to show correctly.
Any solution?
Welcome to UA.
That do you mean by "show them corretly"? Need a bit more here.
If I put a General or Time/Date field it shows 1,23654 instead of 28:45.
created a code (in a module) that transform the 1,2234 fomat in 28:45 format and I connected to a text field so, if I have a multiple row, it shows the same value for all the rows.
I think I need some kind of formula to convert from 1,2222 to 26:23
Sorry for may English and thanks
Filipe Lopes
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.