Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 09-19-2013, 05:02 AM
BobBridges's Avatar
BobBridges BobBridges is offline Multiple Check In/check Out Times Windows 7 64bit Multiple Check In/check Out Times Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Pecoflyer, I liked your answer at first but I just reread his question and I think we both misunderstood. Your answer is correct if 1.25 means one and a quarter minutes; the conversion you recommend will produce a result of 1:15. But now that I read more carefully, I think what he's saying is that 1.25 means 1 min 25 sec. If that's so, maybe the solution is simpler:

Big0, who writes the times into this spreadsheet? If it's you, for 1 min 25 sec don't enter "1.25", enter "0:1:25". To Excel that means 0 hr, 1 min, 25 sec. And, as Pecoflyer said, make sure those cells are formatted as "mm:ss", or perhaps as "[m]:ss", so that they'll be displayed properly. Then calculations you do with the time values should work correctly.

That's assuming you want the spreadsheet to work immediately, at courtside. If you're just entering the times at the game and have leisure to work out the totals afterward, then it's probably easier to enter "1.25" at the time and convert them to something you can do proper arithmetic with later. We can tell you how to do that, but I'm guessing you want the results right away, and if so you need to use the colons and the leading 0 so that Excel will know you're talking about minutes and seconds.

There is another possibility: You can have one cell for minutes and the next one for seconds. Using that, you can enter 1<Tab>25, and have the worksheet set up to convert that to 1:25.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Check In/check Out Times Check Box move to right Johnammo Word 6 09-01-2013 10:07 AM
Multiple Check In/check Out Times cannot check/uncheck check box but added check box learn2office Word 1 11-27-2012 02:02 AM
Link word check box to access check box Mrkieth Word 4 01-30-2012 06:43 AM
Multiple Check In/check Out Times This should be easy - check box RIKIL Mail Merge 10 07-19-2011 08:03 PM
Need Help with Using a Check Box Nick9589 Excel 1 05-01-2010 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft