adding times

S

Saima

Hi everyone

I need help in creating a flexi sheet and i am not sure which formulas
to use

Any help is welcome
 
J

Jerry W. Lewis

Time is stored as decimal fraction of a day (e.g. 1:00pm = 13/24), so
you can simply add times. If the total is to exceed 24 hours, you need
to format to the time format "37:30:55" or the custom format "[h]:mm:ss"

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top