• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 712
  • Last Modified:

convert to working hours: minutes : seconds (netsuite Data)

I get data from a crm called Netsuite:

all is good apart from Time to close:

it returns data (via a web query)

as

0.024031119
0.109186322

0.024031119 = 34 mins. 36 secs.      
0.109186322 = 2 hrs. 37 mins.      



i need it as hours: mins: secs
0
James Murrell
Asked:
James Murrell
1 Solution
 
SteveCommented:
well... you can use:

=TEXT(A1,"hh:mm:ss")


or just apply hh:mm:ss to the cell format
Example.xlsx
0
 
Mark WillsTopic AdvisorCommented:
Here you go... It is simply the floating point number for time...

select convert(datetime,0.024031119)

oh dang.... it is not SQL...

Best to format the cell as a time as The_Barman has already done (except use the 24 hour format, not the AM/PM one)

(and just saw your update via linked in, so thought I would post something here, but The_Barman has your answer for you :) )
0
 
James MurrellProduct SpecialistAuthor Commented:
Thanks - simple thing, that i forgot... big thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now