LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Time with minutes and seconds

I am wanting to work with only minutes and seconds on a spead sheet to add
minutes of cellular time together. When I enter the minutes and seconds, it
converts to hours. Is their any way to do it. I am also havving the
problem, that it is giving the time a AM or PM in the formula. Thanks for
any suggestions.
--
Mark Foley
Village of Glen Carbon
 
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 and Adding Hours, Minutes, and Seconds in a CALL LOG EmanJR Excel Worksheet Functions 1 August 3rd 06 03:47 PM
Time inputted as minutes and seconds Excel edbarunning New Users to Excel 3 May 19th 06 01:14 PM
Average time for a race in minutes seconds & tenths Gammalite Excel Worksheet Functions 1 March 28th 06 03:50 AM
How do I sum increments of minutes and seconds SandyMichalski Excel Worksheet Functions 5 February 2nd 06 03:02 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


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