Hallo

I have a quistion about time formats in exel too.

If I f.ex have the time 1 minut and 31 seconds (tt:mm:ss) = 0:01:31 but i
want the time only in seconds (ss) = 91.

How do I do that?

I hope you can help me!

Greetings

Mikkel



"Alexander" wrote:

Yes, but what if I want the weekday change after time has been accumulated
over 24 hrs? Any chances?

"Roger Govier" wrote:

Hi Alexander

Excel stores time as fractions of a day, so 12 hours = 0.5. So in A2
=A1+0.5

If you were wanting to add times that were not as simple as that, e.g. 5
hours, then
=A1+5/24
or
=A1+TIME(5,0,0)

--
Regards

Roger Govier


"Alexander" wrote in message
...
Dear all,

If A1 is equal to Mon 1300, and when I plus another 12hrs in A2, it
will
become Tue 0100 in A2.

Any idea how to achieve this?

Thanks!