LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hans Peter
 
Posts: n/a
Default Tracking time

I want to find the lap time in minutes and seconds without having to fill inn
the whole string tt:mm:ss. That is very time consuming when all I want is to
display the difference between 16:43 and 25:16. Now I have to write 0:16:43
and 0:25:16. I hope to be able to write 16,43 and 25,16 (or 16.43 and 25.16).
Any suggestions?
Many thanks in advance.
 
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
Combine Date & Time Cells KrunoG Excel Discussion (Misc queries) 0 January 31st 06 08:08 PM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
Tracking Time (Hours/Mins) sdmccabe Excel Discussion (Misc queries) 1 February 1st 05 04:39 PM


All times are GMT +1. The time now is 12:36 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"