LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Des Des is offline
external usenet poster
 
Posts: 19
Default How can I perform calculations in Excel using time?

I have created a spreadsheet in Excel, tracking the time it took (minutes and
seconds) for each mile of a marathon (26 miles, 385 yards). I am trying to
find a way to get Excel to add the times, thus giving me the total time it
took to complete the race...I'm having difficulty finding the correct format
for the time for each mile, and how to get Excel to add it, giving me an
answer in hours and minutes. Is there any way to do this?
 
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
How can I perform calculations with hexadecimals Kingcop Excel Discussion (Misc queries) 1 November 6th 07 12:47 AM
How do i perform calculations on filtered data ALRose Excel Discussion (Misc queries) 0 August 14th 07 03:08 PM
perform calculations in 2 sheets Davidgg Excel Worksheet Functions 0 December 20th 06 03:39 PM
perform calculations using time arguments Derek Excel Worksheet Functions 2 May 20th 06 03:55 AM
Best technique to perform multiple calculations ? [email protected] Excel Worksheet Functions 5 January 25th 05 03:49 AM


All times are GMT +1. The time now is 02:40 PM.

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"