Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This is a 2 part question.
I have cells formatted as [hh]:mm:ss. I enter a time of 5 minutes and 10 seconds as 0:05:10. The cell displays the same as I typed it. In the formula bar it displays as 12:05:10 AM. Am I correct that there is no way to have the formula bar only display 05:10? 2nd question: I want to find the average of times and have them display as a decimal. The times I am averaging are (all min:sec): 5:00, 10:10, 5:10, 5:00, 5:13. The result I get when formatted as [hh]:mm:ss is 00:06:07. How do I have this show as a decimal? Do I just multiply by 24 for the result of .10183? That just doesn't seem quite right. Thanks for your help! -- maryj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time and negative time | Excel Worksheet Functions | |||
calculating time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |