Honduras2811
New member
- Joined
- Jun 19, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I have a cell that shows a calculated time in HH:MM format. The cell is formatted as Time. I would like to convert the contents of the field to seconds. I've tried the Convert function, but it gives me an error.
I've tried =((Hour(I4) * 3600) + (Minute(I4) * 60)) but the result is always 00:00.
Can someone tell me what I am doing wrong?
I've tried =((Hour(I4) * 3600) + (Minute(I4) * 60)) but the result is always 00:00.
Can someone tell me what I am doing wrong?