Skip navigation
Emanuele Radaelli
Emanuele Radaelli
Currently Being Moderated

Performing SUM with time data

May 9, 2010 1:44 PM

Hi,

is there a way to sum time data as following?

 

start_time: 10,15 AM

stop_time: 2,35 PM

 

I expect to do something like:

=(stop_time - start_time)

but this doesn't work.

 

Thanks anticipately.

481 Views   1 Reply   Latest reply: VarunParmar, Jun 10, 2010 10:48 PM
 
Replies
  • VarunParmar
    Currently Being Moderated
    1. VarunParmar,
    Jun 10, 2010 10:48 PM   in reply to Emanuele Radaelli
    Report

    Currently we support arithmetic formulas on 12 hour intervals only, i.e., you can perform the following action (Stop_time - Start_time) for Start_time: 1:00AM and Stop_time: 9:00AM.  Tables will display 8:00AM as the result.  Please make sure you select "date" as the data type for all the columns associated with this operation.

     

    Thanks,
    Varun

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points