Set Home| Set Favorite|

WPS Office Forum

 Forgot password?
 Register
Search
View: 1248|Reply: 1

How to show date with time?

[ Promote this link! ]
Post time: 2013-08-10 03:26:03
| Show all posts |!read_mode!
Dear all,

I am new with spreadsheets, I need help on how to show date with time > "01 Jun 2013 3pm".
And need to show the hours different as well. > "01 Jun 2013 3pm" - "01 Jun 2013 5pm" -- 2 hours different.


Thank you.


Jason
Reply

Use magic Report

Post time: 2014-11-19 16:55:20
| Show all posts
In spreadsheet, go to Format > Conditional Formatting. It's pretty self-explanatory
You have to log in before you can reply Login | Register

Points Rules

Dark room|Mobile|Archiver|WPS Office   

2019-08-18 02:08 GMT+8 , !processed_in! 0.075006 !seconds!, 16 !queries! .

Powered by Discuz! X3.2

Release 20151208, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 469, © 2009-2019 codersclub.org

!fastreply! To Top !return_list!