Forum Discussion

gilbo56's avatar
gilbo56
Copper Contributor
Mar 30, 2020

Converting time format in Excel

I have a spreadsheet with TIME in the format HH:MM:SS (e.g. 09:17:20 AM) and the time zone UTC+10. I need to convert this time to DECIMAL in the time zone UTC.

How can I do this? I can't seem to add or subtract the current time and the MOD function produces a silly result.

1 Reply

  • Substandard's avatar
    Substandard
    Brass Contributor
    Mar 31, 2020
    gilbo56
    Would this link help you with your current problem?
    https://support.office.com/en-us/article/format-numbers-as-dates-or-times-418bd3fe-0577-47c8-8caa-b4d30c528309
    If not, just do a simple search for formatting cells in Excel.

Resources