Hi Concern,
I have attached the excel file for converting ceil function to use excel
and tried different way and not desired achieved the output
in detail,
TOTAL_DURATION ANSMIN RoundedMIN
01/11/2016 19,264,506.00 321,075.10 334,112.40
=> ANSMIN = TOTAL_DURATION /60
FROM SQL LOGIC:
=> RoundedMIN = ((Round((TOTAL_DURATION)/6)*6)/60)
OR
=> RoundedMIN = ((CEIL(TOTAL_DURATION/6)*6))/60
here the concern is how to convert the sql logic into excel or access to get the result (334,112.40)
Regards,
Siva
Hi,
This is gonna be difficult because i can't recreate your sample outcome using the SQl statements you've supposedly used.
So theoretically
Your SQl statement RoundedMIN = ((Round((TOTAL_DURATION)/6)*6)/60) would be this in Excel =ROUNDUP(C2/6,0)*6/60 and RoundedMIN = ((CEIL(TOTAL_DURATION/6)*6))/60 would be =((CEILING(C2/6;1)*6))/60
But as said it's theoretical cause these statements do not evaluate into the correct answer as per your file.
HtH,
Joris
--------------------------------------------------------------------------------
If you found my answer helpful, please hit the Like or Thank button.
Please follow the forum Rules and Guidelines and use Code tags around your VBA code.
Remember: test VBA code always on a copy of your file because usually you can't use undo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks