Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HH:MM question

Status
Not open for further replies.

primagic

IS-IT--Management
Jul 24, 2008
476
GB
I have a cell (A1) with total hours which is in a custom hh:mm format. The value in here is 08:00

I have another cell (A2) with total days which is in number format. The value in here is 5.

In cell A3 I have a formula - A1*A2. This cell is formatted as hh:mm. I would assume the formula would give me 40:00. But I am getting 16:00.

Any idea why?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top