count time format as decimal
 

Hi all,

I was meaning to answer to a message from Tom, but of some strange reason I
could´nt send it from the box, ( anyone no why?)

So I´ll go this way instead.

This is my questionreply

"Hi Tom

Thanks for your replay!

I´m sure it works fine, but can you help to translate it into the Swedish
version, as I´m getting a formula error.
I´ve translated MOD as REST, but it seems like theres something more to be
changed.
Maybe I´m using the wrong format?"

Thanks,
Thomas

Tom Ogilvy" skrev i meddelandet
...
assume 22:00 in B1, 01:15 in C1

in D1=MOD(C1-B1,1)*24*100

--
Regards,
Tom Ogilvy