Filter löschen
Filter löschen

excel decimal time conversion

4 Ansichten (letzte 30 Tage)
David C
David C am 28 Mär. 2013
I have a PW protected excel spreadsheet that has a date/time column, but formatted as "general"
using xlsread, the timestamps (ie 8:51:42) are read into matlab as the numberic formatted time of 0.3692
How do you convert this decimal into the actual time?
datestr(0.3692) gives 1:15 PM and not the 8:51:42 that I expected to get
All help is appreciated!

Antworten (1)

Azzi Abdelmalek
Azzi Abdelmalek am 28 Mär. 2013
datestr(0.3692,'HH:MM:SS')
  1 Kommentar
David C
David C am 28 Mär. 2013
as i mentioned above, datestr gives a different answer
must have something to do with how excel converts a time into a decimal :(

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by