easy formula question
The time is actually a fraction of a day. Replace 20 (minutes) with
20/60/24, since there are 60 minutes in an hour and 24 hours in a
day. 3 x 20/60/24 should give 1:00 when formatted as time.
Good luck
Ken
Norfolk, Va
On May 28, 1:41*pm, j lunis wrote:
How do I perform math calculations on time increments?
For example, 7 * 20 minutes = 2 hours, 20 minutes (2:20),
and 3 hours - 1 hour ten minutes = 1 hour, 50 minutes (1:50).
I know how to format cells to show time but I can't find how to
calculate an answer that shows up as time.
|