[Solved] Converting a time stamp into decimal hours?

[clandis2]

I tried a search and could not find this.

I have a timesheet program on my Palm Pilot that returns an elapsed time in the format HH:MM:SS AM. Is there a way to take this and convert it to decimal hours, such as HH.HH?

Thanks for any help.

[Charlie Young]

I tried a search and could not find this.

I have a timesheet program on my Palm Pilot that returns an elapsed time in the format HH:MM:SS AM. Is there a way to take this and convert it to decimal hours, such as HH.HH?

Thanks for any help.

Assuming the elapsed time is the usual sort of spreadsheet time value, with the integer portion being the date and the fractional portion being the time, just multiply the fractional portion by 24 and format it as 00.00. That is (timevalue - INT(timevalue)) times 24. If there is no date portion, you don't need to do the subtraction, but since then the INT part would be zero, it shouldn't matter.

[clandis2]

Thank you! I was expecting something much more complicated!

[clandis2]

Now, how do I mark this as "Solved"?

[Hagar Delest]

You've to manually add '[Solved]' at the beginning of your first post title (edit button).

[clandis2]

Thank you Hagar!