ExcelBanter - excel 2007 time function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel 2007 time function (https://www.excelbanter.com/excel-discussion-misc-queries/189068-excel-2007-time-function.html)

Sue

excel 2007 time function

I have 26:55:14 in time and I want to use a function to convert it capable of
calcuation (sum) Is this possible?
--
Sue

Niek Otten

excel 2007 time function

Hi Sue,

=Timevalue(A1) and then format as [hh]:mm:ss

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue" wrote in message ...
|I have 26:55:14 in time and I want to use a function to convert it capable of
| calcuation (sum) Is this possible?
| --
| Sue

All times are GMT +1. The time now is 04:47 AM.