advanced excel training - Time; hours:Mins

The UK's most regular instructor-led training courses.
Training information: advanced excel training · Excel/courses/london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Time; hours:Mins

Alistair has attended:
Excel Advanced course

by - delegate Alistair [19 posts] (2007 Mar 9 Fri, 17:39) Reply

Hi,

I'm working in hours and minutes on a spreadsheet. I wish to add up a bunch of times to find the total time. For example 5 days at 8:30 hours (or 8.5) should equal 42:30 (or 42.5), but excel displays the total as 18:30. I have tried the diferent formats for time but can't find anything suitable. Any suggestions?

Cheers
ALi.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	4	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Time; hours:Mins

by - delegate Alistair [19 posts] (2007 Mar 9 Fri, 17:41) Reply

Ooops! Found the answer in you tips section! Cheers.

Also I can't find a search function on your site to search tips and the forum. Do you have one?

· How to Create Better Excel Spreadsheets: Part Two
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel's Best Kept Secret

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips