How can I convert this data into a total hours format instead of date and time
This data should represent three thousand three hours, fifty two minutes and four seconds.
3303:52:04
Instead it show in excel as 5/16/1900 3:52:04 PM
How can I change it to total hours and not time????
georgereni (IS/IT--Manageme) Jun 21, 2004
to all who can help:
I am exporting a report from our internal reporting server that has information in a time format for each employee.
Example:
LastName, FirstName, Login Time
Smith John 3305:31:40
Which means that John Smith has...
to all who can help:
I am exporting a report from our internal reporting server that has information in a time format for each employee.
Example:
LastName, FirstName, Login Time
Smith John 3305:31:40
Which means that John Smith has been logged in for Three Thousand five...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.