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
|