Hi,

How does one convert time to number or text?
Examples:

00:30:00 to show as .50
80:00:00 to show as 80
12:00:00 to show as 12.50

Any help is appreciated.

Thanks,
Lev