09-16-2008, 10:43 AM | #1 |
Red Dragon
Join Date: April 1, 2003
Location: The Midlands
Posts: 1,571
|
Excel Help please.
I’m trying to do something that should be simple, but I just can’t get my head round it.
One team divide their time up into blocks of 6 hours. They want something so they can type in the total number of blocks (this changes) say 15, and this will return the answer of 90:00 (90 hours:00 mins) 6 hours multiply by 15 blocks. The 6 hours never change but the number of blocks will. They want it displayed in the HH:MM format. Then they have a cell with the actual time spent, this again could be anything in HH:MM format, say 75:30. Then a final cell which shows the difference between the two sets of time. I feel this should be nice and easy but when I convert to HH:MM I get a blank cell or instead of say 75:30 I get 03:30. Please tell me how to do this. Hope this makes sense! Cheers.
__________________
Smoke me a kipper...I'll be back for breakfast!! If you can keep your head when all around are loosing theirs...you probably haven’t grasped the situation!! |
09-16-2008, 11:30 AM | #2 |
Jack Burton
Join Date: July 19, 2003
Location: an expat living in France
Age: 38
Posts: 5,577
|
Re: Excel Help please.
The HH:MM format only gives you the rest over from whole days, so if the result would be 25:34 you'd get 01:34.
Try setting the format of your cells to HH:MM:SS (not the first one, towards the end of the list, the example for this format given by Excel is 37:30:55). Hope that helps!
__________________
|
09-22-2008, 10:55 AM | #3 |
Silver Dragon
Join Date: August 2, 2006
Location: i ngach aon áit (but mostly Western Europe)
Age: 56
Posts: 1,619
|
Re: Excel Help please.
Let me know if you still need anything on this
__________________
Make a decision, even if it's wrong, and remember.... ...it's never too early for a salad. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel question | ZFR | General Discussion | 2 | 03-28-2007 05:16 AM |
Need help with Excel.. | Kakero | General Discussion | 3 | 11-15-2005 06:13 AM |
VBA in Excel | Jorath Calar | General Conversation Archives (11/2000 - 01/2005) | 5 | 02-10-2004 11:18 AM |
Help with excel and logarithmic scales | philip | General Conversation Archives (11/2000 - 01/2005) | 8 | 12-31-2003 07:22 PM |
Excel...Some Help Needed... | FelixJaeger | General Conversation Archives (11/2000 - 01/2005) | 4 | 04-22-2003 08:58 AM |