Walker85
asked on
decimal time convertor
Hi
I want to create a simple form or calculator that will sit in an exsisting spredsheet that will allow user to enter a time that will display the decimal time so they can update a value in the same sheet
Hope that makes sense
Thanks
I want to create a simple form or calculator that will sit in an exsisting spredsheet that will allow user to enter a time that will display the decimal time so they can update a value in the same sheet
Hope that makes sense
Thanks
ASKER
Think you I will dig one out as soon as I can
by decimal time do you mean 8:15 = 8.25 or do you want the internal time value that is stored in a datetime field?
ASKER
Yes. So 25 50 75 etc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi sorry about delay in replying I have been away this looks like the answer it will be used to monitor lateness so for example if some was 36 mins late it would convert to decimal
If a person was supposed to be somewhere at 8AM and they arrive at 8:15, what should the answer be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to take into account that someone could be early then use this
=IF(A1>B1,MOD(A1-B1,1)*-24 ,MOD(B1-A1 ,1)*24)
which will show the difference with a negative sign.
=IF(A1>B1,MOD(A1-B1,1)*-24
which will show the difference with a negative sign.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have not selected my comment
br
Nurul