Christiann
New Member
- Joined
- Nov 18, 2020
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
Hello Smart People! I have a situation with converting time from a timecard to decimal form in a spreadsheet.
Here's how far I've gotten: I know the formula to convert the clocked time (4:30) to decimal (4.5).
What I don't know how to do is to embed that formula in each cell so that when I type in the clocked time (4:30) the cell is automatically changed to the decimal (4.5). I don't want to create separate columns where i put in the clocked time because then I have to hide all of the raw data when sending in the spreadsheet electronically.
Any help would be amazing! Thank you!
Here's how far I've gotten: I know the formula to convert the clocked time (4:30) to decimal (4.5).
What I don't know how to do is to embed that formula in each cell so that when I type in the clocked time (4:30) the cell is automatically changed to the decimal (4.5). I don't want to create separate columns where i put in the clocked time because then I have to hide all of the raw data when sending in the spreadsheet electronically.
Any help would be amazing! Thank you!