+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, Excel: Time totals over a year in Technical; Hi all, Ok, feel a little daft posting problems in Excel, but google has let me down I have a ...
  1. #1
    Tyiell's Avatar
    Join Date
    Apr 2009
    Location
    Like everyone in IT - I'm omnipresent...
    Posts
    373
    Thank Post
    147
    Thanked 67 Times in 44 Posts
    Rep Power
    24

    Excel: Time totals over a year

    Hi all,

    Ok, feel a little daft posting problems in Excel, but google has let me down

    I have a spreadsheet that totals up time spent on the phone in the format hh:mm:ss. I then want to total this up over the year. Trouble is, it thinks I'm actually recording the time of day, rather than a total, so it goes back to 0 after midnight!

    Is there a way to total time dangling directly in front of my face that I'm missing??

    Cheers all

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764

  3. Thanks to SYNACK from:

    Tyiell (10th March 2010)

  4. #3
    Mako's Avatar
    Join Date
    Apr 2009
    Location
    North Yorkshire
    Posts
    431
    Thank Post
    50
    Thanked 107 Times in 81 Posts
    Rep Power
    71
    Hi Tyiell,

    I'm assuming you have already formatted the cells in the spreadsheet to automatically display numerical input as time to give, what you've already stated, as hh:mm:ss format.

    Indeed, excel interprets this as time of day, rather than just time.

    You'll need to highlight the cells again> Format Cells > Number > Custom

    Scroll down the Custom Type list, until you see [h]:mm:ss and use this as the format type. The square brackets are indicitive of the output type you need, ignore all other time formats.

    Should be the solution you need.

    EDIT: Beat me to it, Synack!

  5. Thanks to Mako from:

    Tyiell (10th March 2010)

  6. #4
    Tyiell's Avatar
    Join Date
    Apr 2009
    Location
    Like everyone in IT - I'm omnipresent...
    Posts
    373
    Thank Post
    147
    Thanked 67 Times in 44 Posts
    Rep Power
    24
    Quote Originally Posted by Mako View Post
    Hi Tyiell,

    I'm assuming you have already formatted the cells in the spreadsheet to automatically display numerical input as time to give, what you've already stated, as hh:mm:ss format.

    Indeed, excel interprets this as time of day, rather than just time.

    You'll need to highlight the cells again> Format Cells > Number > Custom

    Scroll down the Custom Type list, until you see [h]:mm:ss and use this as the format type. The square brackets are indicitive of the output type you need, ignore all other time formats.

    Should be the solution you need.

    EDIT: Beat me to it, Synack!
    Perfect! Thank you!!

  7. #5
    Tyiell's Avatar
    Join Date
    Apr 2009
    Location
    Like everyone in IT - I'm omnipresent...
    Posts
    373
    Thank Post
    147
    Thanked 67 Times in 44 Posts
    Rep Power
    24
    Clearly my Googling skills need honing. Appologies

  8. #6
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Yes you have much to learn young grasshopper.. and maybe someday you will be a Google Fu master
    Last edited by apeo; 10th March 2010 at 03:52 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 22nd December 2009, 05:05 PM
  2. New netbooks(?) for Year R/Year 1
    By LeMarchand in forum Hardware
    Replies: 15
    Last Post: 12th March 2009, 02:39 PM
  3. Best Time Of The Year.
    By russdev in forum General Chat
    Replies: 13
    Last Post: 13th September 2007, 08:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •