Thread
:
How to convert time into "block time"?
View Single Post
#
4
Sandy Mann
Posts: n/a
Mangesh,
Do you by any chance use semicolons as separators in formulas instead of
commas?
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"Bengt Bergholm" wrote in message
...
Thanks for the formular Mangesh, unfortunatley it doesn't work, Excel
complains about som error in the formula when I try to adapt it
(standard formula error mess). After OK'ing the dialog it highlights the
10,0 part. See attached screenshot.
BoB
Mangesh Yadav wrote:
A1 contains your time, the use:
=ROUNDUP(A1*24*10,0)/10
Mangesh
"Bengt Bergholm" wrote in message
...
Sorry for my lack of terminology here but I need help to accomplish the
following:
From cells containing time in format 0:12, 1:18 etc, meaning 12 minutes
and one hour and 18 minutes converting it according to:
1-6 minutes = 0.1
7-12 minutes = 0.2
13-18 minutes = 0.3
19-24 minutes = 0.4
25-30 minutes = 0.5
31-36 minutes = 0.6
37-42 minutes = 0.7
43-48 minutes = 0.8
49-54 minutes = 0.9
55-60 minutes = 1.0
61-66 minutes = 1.1 etc etc...
That is, rounding and displaying as 10th's of the hour depending on how
many minutes there are in the input cell.
Any ready-to-use formula or vba-script would be greatly appreciated! :)
BoB
--------------------------------------------------------------------------------
Reply With Quote