I am using OpenOffice::OODoc to write data into an OpenOffcie spreadsheet. I want to write a time variable with the format HH:MM into a cell. I set the type of the cell like this: $doc->cellValueType($cell, 'time'), but there is no formatting like HH:MM. What is the solution to write exactly the time into the format HH:MM?

I don't know about OpenOffice::OODoc module. But if you want to write contents in spreadsheet you can use Spreadsheet::WriteExcel module.This module is very easy for writing the data in spreadsheet via perl. This is my opinion.