Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
As long as it works, well and good. :)
Mangesh "Bengt Bergholm" wrote in message ... You're right, it works with a semi-colon, strange though, I tested that already since I know of this delimiter problem but it didn't work then but now it does... Thanks! Mangesh Yadav wrote: Hi Bengt, Your system requires you to use the semi-colon (;) instead of a comma (,) as can be seen from your screen shot. So in my formula replace the comma with a semi-colon, something like this: =ROUNDUP(A1*24*10;0)/10 Mangesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
How do I convert time (2:30) to a number (2.5) in a formula? | Excel Worksheet Functions | |||
subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
In Excel how can you convert a cell formatted for time (4:30) to . | Excel Worksheet Functions | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |