Binod Singh 0 Report post Posted March 27, 2005 It seems very simple but, I have tried almost all available formatting styles to enter a particular time in a excel sheet. Basically, I have to calculate the difference between two times in the form of hours, minutes and seconds for which the function Text(?cell reference?, HH, MM, SS) may be used but only after the time period is entered in time format. Whenever I enter the time and try to format using Format -> cells->time?. the data is changed to some another time and the time format is applied. If anyone knows, please reply. Share this post Link to post Share on other sites