The Glade 4.0

Can you set up formulas in Excel to calculate time? If so, how?

Basically, I'm trying to create a quick show cutsheet with each item assigned a certain duration, and need that column to autocalculate time (60 minutes).

Thanks in advance.

/hates having to clean up other people's messes late at night and with little time.

fast answer : Timesheet Templates at Office Online ...

Also, if you enter times in hh:mm format, the =SUM() formula should add them correctly. I tested this by entering "8:30:15" in one cell and "2:15:45" in another. The sum formula displayed "10:46" as it's result.

One of the most useful resources I've discovered since coding in Excel/Access is ozgrid.com : Formulas : How to add up minutes and hours.

_________________
Go back to zero, take a pill, and get well ~ Lemmy Kilmister

THANK YOU.

Quite welcome. It's pretty much what I've been doing for a living since October : Googling things like "Excel add hours and minutes" or "Excel VBA progress bar". I swear I've learned more just by searching the internet for answers to problems I actually face on the job than I ever did sitting in a classroom trying to concoct real-world applications for homework assignments.

_________________
Go back to zero, take a pill, and get well ~ Lemmy Kilmister