View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jonsson Jonsson is offline
external usenet poster
 
Posts: 45
Default 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