locked
more than 24 hours RRS feed

  • Question

  • Hallo

    Is it possible to put more than 24 hours in a (date-)field?

    example: I have worked 30:00 hours on a project

    thanks

     

    VGNTS

    • Moved by David Wolters Tuesday, July 13, 2010 3:41 AM Wrong Forum (From:Office 2010 Beta (Archive))
    Monday, June 28, 2010 1:46 PM

Answers

  • Hi

    Format the cell with the summation formula as [h]:MM



    Regards
    Roger Govier

    "VGNTS" wrote in message news:57553196-4d94-42bf-8b87-68d49da1ce2d@communitybridge.codeplex.com...

    I forgot to mention that is in Access.

    I want to make the sum of fields that contain the difference between the beginning time and the ending time.

    If that is possible in a duration field, how have I to do that?

    thanks


    ________ Information from ESET Smart Security, version of virus signature database 5235 (20100628) ________

    The message was checked by ESET Smart Security.

    http://www.eset.com

    ________ Information from ESET Smart Security, version of virus signature database 5235 (20100628) ________

    The message was checked by ESET Smart Security.

    http://www.eset.com


    Roger Govier Microsoft Excel MVP
    • Marked as answer by Sally Tang Tuesday, July 13, 2010 6:22 AM
    Monday, June 28, 2010 9:26 PM

All replies

  • What application are you talking about ?

    Date fields would normally contain a date (and possibly a time).

    A duration field would contain a number of minutes/hours/days/weeks.


    Simon Jones http://pcpro.co.uk
    Monday, June 28, 2010 2:12 PM
  • I forgot to mention that is in Access.

    I want to make the sum of fields that contain the difference between the beginning time and the ending time.

    If that is possible in a duration field, how have I to do that?

    thanks

    Monday, June 28, 2010 2:19 PM
  • Hi

    Format the cell with the summation formula as [h]:MM



    Regards
    Roger Govier

    "VGNTS" wrote in message news:57553196-4d94-42bf-8b87-68d49da1ce2d@communitybridge.codeplex.com...

    I forgot to mention that is in Access.

    I want to make the sum of fields that contain the difference between the beginning time and the ending time.

    If that is possible in a duration field, how have I to do that?

    thanks


    ________ Information from ESET Smart Security, version of virus signature database 5235 (20100628) ________

    The message was checked by ESET Smart Security.

    http://www.eset.com

    ________ Information from ESET Smart Security, version of virus signature database 5235 (20100628) ________

    The message was checked by ESET Smart Security.

    http://www.eset.com


    Roger Govier Microsoft Excel MVP
    • Marked as answer by Sally Tang Tuesday, July 13, 2010 6:22 AM
    Monday, June 28, 2010 9:26 PM
  • Hi

    Sorry for the late reply, I wasn't working yesteday.

     

    The format given by Roger works well in Excell, but not in Access.

    When I have 25 hours the result for a date-field = 31/12/1899 1:00:00

    If I format the cell like [h]:MM the result is 01:00

    Thats not what I want. I want it as 25:00

    • Marked as answer by Sally Tang Tuesday, July 13, 2010 6:22 AM
    • Unmarked as answer by Sally Tang Tuesday, July 13, 2010 6:22 AM
    Wednesday, June 30, 2010 11:12 AM