Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Trouble with time in column

Unanswered Trouble with time in column

  • Tuesday, April 24, 2012 2:23 PM
     
     
    Sign In to Vote
    0

    hi,

    when i substract two column contain date+time into a third column like this:

    =[Fin]-[Début]

    the result is bad:

    any idea?

    thanks.

    Marc.

     

All Replies

  • Tuesday, April 24, 2012 2:41 PM
     
     
    Sign In to Vote
    0

    Hello,

    Mathematical operations are different than the date-time operations.

    Please refer: http://msdn.microsoft.com/en-us/library/bb862071.aspx

    Hope this helps,

    Regards, Rohan --Please mark as "Answer" if the post resolve your issue--

     
  • Thursday, May 03, 2012 7:42 AM
     
     
    Sign In to Vote
    0

    hi,

    i try this formula:

    =TEXT([Fin]-[Debut],"h:mm")

    and i get this error:

    any idea?

     
  • Friday, May 04, 2012 10:55 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    I have tested it in my environment and it is working. Just follow the same:

    1. Insert this formula: =TEXT([Created]-[Modified],"H:MM")
    2. For data type, select “Date and Time”
    3. For date and time format, select “Date and Time”
    4. Click OK

    Also check the log file if above steps don't work.

    Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

     
  • Tuesday, May 22, 2012 11:55 AM
     
     
    Sign In to Vote
    0

    hi,

    i always have the same error.

    tanks.