The Glade 4.0
https://gladerebooted.net/

Quick Spreadsheet Question
https://gladerebooted.net/viewtopic.php?f=2&t=3230		 Page 1 of 1
Author:  FarSky [ Tue Jun 15, 2010 9:32 pm ]
Post subject:  Quick Spreadsheet Question
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.
Author:  Shelgeyr [ Tue Jun 15, 2010 9:50 pm ]
Post subject: 
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.
Author:  FarSky [ Tue Jun 15, 2010 11:06 pm ]
Post subject:  Re: Quick Spreadsheet Question
THANK YOU.

:D
Author:  Shelgeyr [ Wed Jun 16, 2010 9:34 am ]
Post subject: 
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.
Page 1 of 1 All times are UTC - 6 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/