Calculating time in OpenOffice Calc
arthezius
Posted messages
3756
Status
Member
-
PengYou -
PengYou -
Hello,
I'm looking to do a time calculation in OpenOffice Calc.
Let me explain:
I have a cell that contains a time in the HH:MM format (I have set the formatting this way).
I have another cell containing a number of minutes (unformatted cell).
I would like to calculate the resulting time from the following operation:
time (HH:MM) + X minutes = resulting time
I would also like the resulting time to be formatted in HH:MM
I have tried some things, but I'm a bit lost actually. I don't use the calculation functions in OpenOffice very much and I'm relatively new to this area.
Thanks to anyone who can help me.
--
“Research begins where knowledge ends.”
I'm looking to do a time calculation in OpenOffice Calc.
Let me explain:
I have a cell that contains a time in the HH:MM format (I have set the formatting this way).
I have another cell containing a number of minutes (unformatted cell).
I would like to calculate the resulting time from the following operation:
time (HH:MM) + X minutes = resulting time
I would also like the resulting time to be formatted in HH:MM
I have tried some things, but I'm a bit lost actually. I don't use the calculation functions in OpenOffice very much and I'm relatively new to this area.
Thanks to anyone who can help me.
--
“Research begins where knowledge ends.”
Configuration: Ubuntu 9.04 Jaunty Jackalope :) Firefox 3.0.10 Bluefish 1.0.7
