Unanswered

Get a row value greater than 24 hours

(0) Share

Report

Posted on by AJStubbsy

Hi, I have an excel spreadsheet where I am counting total hours for work that has been carried out on equipment. I am using a custom format for the cell: -

[h]:mm:ss

I am using 'Get a row', to extract this value and send it as an email but i can't find the correct format to convert the string to the excel cell value i.e. if I have 36:42:30 in the cell, the captured string will be 1899-12-31T12:42:30.000Z

Any suggestions please?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try subtracting midnight zulu time for 1899-12-31 from the time that comes across and see if that gives you what you need.

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@AJStubbsy

If you format the Excel column as a string, no conversion should be required - the value will come through as 36:42:30

Was this reply helpful? Yes No
AJStubbsy 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer ,
Thank you for the response. Can you explain how I would do this please? I've tried using Text format but the number is converted to 1.528125. I can write the value with : but this cell is summing values from a total column.

Was this reply helpful? Yes No