Login Page - Create Account

Support Board


Date/Time: Sun, 12 May 2024 00:24:06 +0000



Post From: Time value in Spreadsheet study

[2024-03-21 03:01:10]
User642012 - Posts: 51
HI

i HAVE SET THE FORMULA AS DISCTIBED BUT CAME BACK WITH NUMBERS 0.3888


PLEASE SEE THE ATTACHED SCREEN CAP.Thanks

AN  AO
=timevalue("09:15:00")  =AN3+TIME(0,5,0)

AN  AO
09:15:00  0.3888888888888889


ANY THING MISSING /

thanks,
imageScreenshot 03-21-2024 10.52.59.png / V - Attached On 2024-03-21 02:58:36 UTC - Size: 27.72 KB - 29 views
Attachment Deleted.
imageScreenshot 03-21-2024 10.52.59.png / V - Attached On 2024-03-21 02:58:58 UTC - Size: 27.72 KB - 28 views