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: 2
Default Calculating times under the second

Hi Everybody!

One question:

I want to calculate the time elapsed from a certain moment, for this purpose
I stored in "A" the value of Now() at the "start" and I read again and
Stored in "B" the value of Now() at the "Stop".

Although I have used the following to format the cell:
Selection.NumberFormat = "mm\:ss.00;@"

in the following statement:
Range("A1")= B-A

I cannot read in A1 any value under the second... how is it possible to
count also that small times?

Thank you for your help

Sergio


 
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
Calculating Times for Pay Rates aussiegirlone[_3_] Excel Discussion (Misc queries) 4 August 26th 09 10:23 AM
Calculating Times Chris waller Excel Discussion (Misc queries) 3 August 11th 09 08:31 PM
calculating pay rates for different times of the day davidesw New Users to Excel 4 November 10th 07 01:58 AM
re calculating numbers to times Hein Excel Discussion (Misc queries) 2 October 3rd 05 08:17 PM
Calculating times gibbylinks Excel Discussion (Misc queries) 4 August 23rd 05 01:27 PM


All times are GMT +1. The time now is 05:54 AM.

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

About Us

"It's about Microsoft Excel"