Time to output in seconds,00

  • Thread starter Thread starter Steinar Vissebråten
  • Start date Start date
S

Steinar Vissebråten

Hi,

I thought to get an output of seconds,00 to a cell was a easy calculation in
Excel - it is not!

I hace to kind of input:
1,12,12/12,12,12 this is a time and minutes can vary from 1 to 20 minutes
thats why two kind of input.
The last input in a cell is just second and two decimals.

This cell I want to make another calculation to another cell. In this new cell
I want the input of cell 1 to be in just second+22 decimals.

12 minutes 12 seconds 12 hundreds =Input 12,12,12 or 7,54,54
The input cell is set to text the same with cell 2

Using this string:
=if(len(a1)=5,a1,left(a1,2)*60+mid(a1,4,2)&","&right(a1,2))
makes no output to cell two for the time entered as: 12,12,12 but it does
calculate the time: 40,00

I have tried several different way to calculate this without any luck. Any
idea?

I do have a hunch that using MID my Norwegian Office does not recognize this
and then what to do? The output mistake is #NAME?

Could someone E-mail me directly?

Steinar.
 
Hei Steinar

MID in norwegian is DELTEKST.

This task would probably be easy in Excel if you used Excel's language and standards when
entering. For beautiful countries with comma as decimal separator, time is entered like
this:
hh:mm:ss,00
so
0:7:54,54
makse sense as time. 7,54,54 is just lyrics and you have to do all the math yourself
afterwards.

No email, sorry. We should keep this publice because everyone probably wonders what MID is
in norwegian.
 
On Sat, 6 Dec 2003 17:36:39 +0100, "Harald Staff" <[email protected]>
wrote:

Hi,

Yes, that was the clue. I had read about it but didn't understood all
correctly.

I know about entering time the way you describe it. But to do the entering of
time it is easier to use komma instead of the semicolon.

I did so just to do some more math after I had settled this problem Harald.

Thanks a lot for the help.

Steinar.
 
Agreed, time entry without dedicated hardware or software assistance is a real pain.

This sounds like some "sports sheet" where data entry speed and accuracy would be
essential, so your solution is probably the best no-macro way to do it.
 
I have this working now but I have more problems!!

Kan jeg sende deg et spørsål direkte om noe annet. Adresse?

Steinar.
Agreed, time entry without dedicated hardware or software assistance is a real pain.

This sounds like some "sports sheet" where data entry speed and accuracy would be
essential, so your solution is probably the best no-macro way to do it.
Click to expand...

Steinar Vissebråten
http://home.online.no/~steinv
 
Steinar Vissebråten said:
I have this working now but I have more problems!!
Kan jeg sende deg et spørsål direkte om noe annet. Adresse?
Click to expand...

No email support, sorry, for a mixed set of reasons. But post to the groups
no.it.programvare.ms-office
or
dk.edb.regneark
if you prefer posting/replies in scandinavian..
 
Back
Top