Open Office Calc Formula to Computer Time Duration
 

Do anyone here knows, formula to compute time duration in calc?
Example:
Time Started Time Finished Duration
08:00AM 09:00 AM = 1 Hour or 1

Thanks in advance.

Working with A1, B1, C1:

• Select A1 and B1 and go Format > Cells and change 'Category' to 'Time' and 'Format' to '01:37 PM'.
• Select C1 and go Format > Cells and change 'Category' to 'Time' and 'Format' to '01:37'.
• Edit A1 to contain the start time, then edit B1 to contain the end time (both in HH:MM:SS format).
• Finally, enter '=B1-A1' in C1 and it will display the difference in times correctly.

Hope this helps,

Thanks for reply but this is not working.
I want to know if i can make a formula to computer time duration.
Example:
Time Started A1= 10:00:00 AM
Time End B1= 10:30:00 AM
Duration C1= 30 Mins.

Yeah i already did it.
Thanks for the reply.

This is the formula Ive done.

Well... The formula I gave should work with your test data (10:00:00 and 10:30:00). Your formula will show the (positive) difference of the two if the start time is after the end time, which is an unlikely occurrence for well-behaved data - however, I don't know the context of your spreadsheet.

If you consider your problem to be solved, please mark the thread as 'SOLVED'. Thanks :)

It looks like his mod is to add a day in case the start/end crosses the 24hr border.

Thanks for all the reply. I am already satisfied on my formula, and i already use it by now.

More powers to LQ.

*facepalm* duhhhh. Sometimes I should remember to switch my brain on. Yeah, that's a more plausible usecase than a start time after your end time...