LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time in 24 hour format to produce hours in decimal format Hercdriver Excel Worksheet Functions 11 December 29th 09 02:06 AM
How to format time in decimal format & calculate time Cheyenne Excel Discussion (Misc queries) 1 February 13th 09 01:37 AM
How to type format time in decimal format & calculate time Cheyenne Excel Discussion (Misc queries) 1 February 13th 09 12:09 AM
How to type format time in decimal format & calculate Cheyenne Excel Discussion (Misc queries) 1 February 12th 09 11:54 PM
count time format as decimal Jonsson Excel Programming 1 February 23rd 04 02:38 AM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"