Over 24:00 problem

[ClimoC]

I know what someone is going to think... "[h]:mm:ss"

That's not the problem.

The finished sheet is a file for importing to third party software. It doesn't handle the "01/01/1900" that is appended to the time when it goes passed 24hrs.

Hundreds of lines of code, do not want to remove them manually.

How can I remove the "01/01/1900" from the cell value?

 

[DonkeyOte]

If you want only the time remainder then use MOD

=MOD(calculation,1)

that will get rid of excess hours...

If you want the value as a text string then use the TEXT function

=TEXT(calculation,"[hh]:mm:ss")

 

[ClimoC]

What if I still need it stored as a number/time...?

 

[DonkeyOte]

As a number 36:00 is 1.5 ... whichever way you look at it... if you're using VBA you might perhaps want to use .Text as opposed to .Value ... this would extract 36:00 as 36:00 rather than 1.5

I confess I have little idea as to what it is you're actually looking to do.

 

[ClimoC]

Its ok. I didn't think the import script would've been a problem with the time/date. Turns out something else was the error. All is well.