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!

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

Time in Excel 1

Status
Not open for further replies.
Rydel

Rydel

Programmer
Feb 5, 2001
376
CZ
Dear gurus,

I have a column of log times (type "time"), and I want to see a sum of it at the bottom. It works fine for sums under 24, but once the sum is bigger than 24, it zeroes out (because the cell is also of type "time"). How can I prevent that from happening? Thanks in advance for your help!!!
---
---
 
Sort by date Sort by votes
Use the elapsed time format, if you look under time formats it is the one with 37:30:55 or under custom formats it is [h]:mm:ss Dawn
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
306
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
301
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
901
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
699
SoftwareRT
SoftwareRT
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
183
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top